GitHub repo - https://github.com/sanjanagupta16/DATA598C-Data-Science-Process

Importing Libraries and setting cwd

library(tidyverse)
## -- Attaching packages ---------------------------------------------------------------------------------------------- tidyverse 1.3.0 --
## v ggplot2 3.2.1     v purrr   0.3.3
## v tibble  2.1.3     v dplyr   0.8.4
## v tidyr   1.0.2     v stringr 1.4.0
## v readr   1.3.1     v forcats 0.4.0
## -- Conflicts ------------------------------------------------------------------------------------------------- tidyverse_conflicts() --
## x dplyr::filter() masks stats::filter()
## x dplyr::lag()    masks stats::lag()
library(plotly)
## 
## Attaching package: 'plotly'
## The following object is masked from 'package:ggplot2':
## 
##     last_plot
## The following object is masked from 'package:stats':
## 
##     filter
## The following object is masked from 'package:graphics':
## 
##     layout
library(ggplot2)
library(naniar)
library(leaflet)
library(htmltools)
library(choroplethr)
## Loading required package: acs
## Loading required package: XML
## 
## Attaching package: 'acs'
## The following object is masked from 'package:htmltools':
## 
##     span
## The following object is masked from 'package:dplyr':
## 
##     combine
## The following object is masked from 'package:base':
## 
##     apply
library(dplyr)
library(choroplethrMaps)
library(ggplot2)
library(gridExtra)
## 
## Attaching package: 'gridExtra'
## The following object is masked from 'package:acs':
## 
##     combine
## The following object is masked from 'package:dplyr':
## 
##     combine
library(ggmap)
## Google's Terms of Service: https://cloud.google.com/maps-platform/terms/.
## Please cite ggmap if you use it! See citation("ggmap") for details.
## 
## Attaching package: 'ggmap'
## The following object is masked from 'package:plotly':
## 
##     wind
library(htmlwidgets)
library(mapview)
library(dplyr)
library(plotly)
library(devtools)
## Loading required package: usethis
library(kableExtra)
## 
## Attaching package: 'kableExtra'
## The following object is masked from 'package:dplyr':
## 
##     group_rows
library(here)
## here() starts at C:/Users/Sanjana Gupta/Desktop/Winter 2020/Data 598C Data Science Process/Data Science Project
#setwd("~/Desktop/Winter 2020/Data 598C Data Science Process/Data Science Project")
#setwd(here("/Data Science Project"))

Importing data and creating a training dataset

data1 <- read.csv(file = "data/listings.csv", header = TRUE)
data2 <- read.csv(file = "data/calendar.csv")
data3 <- read.csv(file = "data/reviews.csv")

data_train <- data1

Viewing the data in different formats

#View(data_train)

#to view data kinda nicely - uses dplyr
#glimpse(data_train)
#str(data1)
#summary(data_train)
#head(data_train, 1000)
#tail(data_train, 50)

Data Understanding & Data Cleanng

  1. Data Cleaning - removing columns
#cols_to_delete <- c("last_scraped", "thumbnail_url", "host_picture_url", "medium_url", "picture_url", "xl_picture_url", "host_thumbnail_url", "host_picture_url")
#select(data_train, -contains("url"))
data_train$last_scraped <- NULL
data_train$thumbnail_url <- NULL
data_train$host_picture_url <- NULL
data_train$medium_url <- NULL
data_train$picture_url <- NULL
data_train$xl_picture_url <- NULL
data_train$host_thumbnail_url <- NULL
data_train$host_picture_url <- NULL
data_train$host_url <- NULL
data_train$scrape_id <- NULL
data_train$experiences_offered <- NULL
data_train$neighborhood_overview <- NULL
data_train$host_about <- NULL
data_train$host_id <- NULL
data_train$host_verifications <- NULL
data_train$host_has_profile_pic <- NULL
data_train$host_identity_verified <- NULL
data_train$calendar_last_scraped <- NULL
data_train$license <- NULL
data_train$instant_bookable <- NULL
data_train$require_guest_profile_picture <- NULL
data_train$require_guest_phone_verification <- NULL
data_train$summary <- NULL
data_train$notes <- NULL
#Down to 69 columns from initial 92

rownames(data_train) <- NULL

#Viewing the data
#glimpse(data_train)
#summary(data_train$is_location_exact)
  1. Converting Data type for price to numeric
data_train$price <- sub("\\$","",data_train$price)
data_train$price <- sub(",","",data_train$price)
data_train$price <- as.integer(data_train$price)
  1. Changing data type of categorical variables to factor
data_train$host_response_time <- as.factor(data_train$host_response_time)
data_train$host_is_superhost <- as.factor(data_train$host_is_superhost)
data_train$neighbourhood_cleansed <- as.factor(data_train$neighbourhood_cleansed)
data_train$is_location_exact <- as.factor(data_train$is_location_exact)
data_train$property_type <- as.factor(data_train$property_type)
data_train$room_type <- as.factor(data_train$room_type)
data_train$bed_type <- as.factor(data_train$bed_type)
data_train$calendar_updated <- as.factor(data_train$calendar_updated)
data_train$cancellation_policy <- as.factor(data_train$cancellation_policy)
  1. Changing host reponse time and extra people from character to numeric
data_train$host_response_rate<- as.numeric(sub("%", "", data_train$host_response_rate))
## Warning: NAs introduced by coercion
data_train$host_response_rate <- data_train$host_response_rate/100
data_train$extra_people <- as.numeric(sub("\\$","",data_train$extra_people))
  1. Checking if Price = 0 for any listings
0 %in% data_train$price
## [1] FALSE

All Airbnb listings have a price associated with it

  1. Removing rows with NA
  2. Removing rows with null values
data_train %>% filter_all(all_vars(!is.null(.)))
data_train %>% filter_all(all_vars(complete.cases(.)))  
  1. Getting a summary of all fields
summary_df <- data.frame(summary(data_train))
#write.csv(summary_df, "summary.csv")
  1. Adding log price column
data_train$log_price <- log(data_train$price)
  1. Checking for missing values and plotting the data
check_missing<- function(x){
  if (is.character(x)) sum(x=="") else sum(is.na(x))
}
NMISS<-data.frame(nmiss=sapply(data_train,check_missing))
#write.csv(NMISS, "missing.csv")

#plotting missing data
missingdata <- data_train
missingdata[missingdata == ""] <- NA
missingdata <- missingdata %>% select(host_is_superhost, review_scores_rating,
                                      host_response_time, name, host_since, zipcode, latitude,longitude,
                                      host_location, host_response_rate,neighbourhood_cleansed,
                                      property_type, price,weekly_price, monthly_price, bedrooms, bathrooms)
gg_miss_var(missingdata) + labs(title = "Missing Values Plot",y = "Missing Data", x = "Attribute")  + theme_bw() + theme(text=element_text(color = "dark blue")) 

  1. Replacing missing values
data_train$review_scores_rating <- ifelse(is.na(data_train$review_scores_rating)==T,97,data_train$review_scores_rating)
data_train$host_response_rate <- ifelse(is.na(data_train$host_response_rate)==T,97,data_train$host_response_rate)

#Using same plot as before to check the values
gg_miss_var(missingdata) + labs(title = "Missing Values Plot",y = "Missing Data", x = "Attribute")  + theme_bw() + theme(text=element_text(color = "dark blue")) 

Data Understanding - plots

  1. Analysing neighborhood grouping
#In neighborhood group cleansed, there are 794 rows with "Other Neighborhoods"
#Need to fix this - maybe look at neighorhood cleansed column instead?
#Looking at categorical data now
sort(table(data_train$host_neighbourhood), decreasing = TRUE)
## 
##              Capitol Hill                                            Belltown 
##                       405                       300                       254 
##                   Ballard                     Minor                Queen Anne 
##                       210                       191                       189 
##                   Fremont               Wallingford         North Beacon Hill 
##                       147                       134                       101 
##                   Ravenna Central Business District                   Stevens 
##                       100                        93                        87 
##                First Hill                 Greenwood       University District 
##                        85                        80                        80 
##          Lower Queen Anne             Columbia City                Green Lake 
##                        75                        61                        55 
##                  Magnolia             North Admiral             Phinney Ridge 
##                        53                        53                        52 
##                  Atlantic                    Leschi               Mount Baker 
##                        49                        46                        44 
##                  Eastlake                   Madrona                Maple Leaf 
##                        42                        40                        40 
##              The Junction                 Roosevelt         Pike Place Market 
##                        39                        32                        31 
##                   Genesee                    Bryant               Seward Park 
##                        30                        29                        27 
##            North Delridge                      Alki                Crown Hill 
##                        26                        22                        21 
##                  Montlake                  Gatewood              Madison Park 
##                        19                        18                        18 
##             Rainier Beach    International District             Mathews Beach 
##                        18                        17                        17 
##          South Lake Union                 Wedgewood               Bitter Lake 
##                        16                        16                        15 
##                 Broadview               Haller Lake                    Dunlap 
##                        15                        15                        14 
##     Harrison/Denny-Blaine               Portage Bay           Victory Heights 
##                        14                        14                        13 
##             Highland Park             Olympic Hills                  Westlake 
##                        12                        12                        12 
##                High Point            Licton Springs    North Beach/Blue Ridge 
##                        11                        11                        11 
##            Pioneer Square            Yesler Terrace                     Holly 
##                        11                        11                        10 
##                Fauntleroy                Georgetown               Laurelhurst 
##                         9                         9                         9 
##               Meadowbrook                Windermere                 Riverview 
##                         9                         9                         8 
##                   Seaview            South Delridge                   Anaheim 
##                         8                         8                         7 
##                 Hollywood                Cedar Park                Holly Park 
##                         7                         6                         6 
##                South Park                View Ridge                  Brighton 
##                         6                         6                         5 
##                  Broadway                  Interbay             Arbor Heights 
##                         5                         4                         3 
##       Industrial District            Fenway/Kenmore             Jamaica Plain 
##                         3                         2                         2 
##                 Kaanapali          Mission District             Baldwin Hills 
##                         2                         2                         1 
##             Beverly Hills         Central San Pedro      Clairemont Mesa East 
##                         1                         1                         1 
##          Downtown Toronto              East Village                Forestland 
##                         1                         1                         1 
##            Hell's Kitchen          Huntington Beach                   Kauaʻi 
##                         1                         1                         1 
##                Long Beach           Manhattan Beach        North College Park 
##                         1                         1                         1 
##           North Hollywood        Northwest District                 Pinehurst 
##                         1                         1                         1 
##                   Roxhill              Santa Monica         South Beacon Hill 
##                         1                         1                         1 
##             Waianae Coast 
##                         1
head(subset(data_train, select = 'neighbourhood_group_cleansed'))
factor(data_train$neighbourhood_group_cleansed)
##    [1] Queen Anne          Queen Anne          Queen Anne         
##    [4] Queen Anne          Queen Anne          Queen Anne         
##    [7] Queen Anne          Queen Anne          Queen Anne         
##   [10] Queen Anne          Queen Anne          Queen Anne         
##   [13] Queen Anne          Queen Anne          Queen Anne         
##   [16] Queen Anne          Queen Anne          Queen Anne         
##   [19] Queen Anne          Queen Anne          Queen Anne         
##   [22] Queen Anne          Queen Anne          Queen Anne         
##   [25] Queen Anne          Queen Anne          Queen Anne         
##   [28] Queen Anne          Queen Anne          Queen Anne         
##   [31] Queen Anne          Queen Anne          Queen Anne         
##   [34] Queen Anne          Queen Anne          Queen Anne         
##   [37] Queen Anne          Queen Anne          Queen Anne         
##   [40] Queen Anne          Queen Anne          Queen Anne         
##   [43] Queen Anne          Queen Anne          Queen Anne         
##   [46] Queen Anne          Queen Anne          Queen Anne         
##   [49] Queen Anne          Queen Anne          Queen Anne         
##   [52] Queen Anne          Queen Anne          Queen Anne         
##   [55] Queen Anne          Queen Anne          Queen Anne         
##   [58] Queen Anne          Queen Anne          Queen Anne         
##   [61] Queen Anne          Queen Anne          Queen Anne         
##   [64] Queen Anne          Queen Anne          Ballard            
##   [67] Ballard             Ballard             Ballard            
##   [70] Ballard             Ballard             Ballard            
##   [73] Ballard             Ballard             Ballard            
##   [76] Ballard             Ballard             Ballard            
##   [79] Ballard             Ballard             Ballard            
##   [82] Ballard             Ballard             Ballard            
##   [85] Ballard             Ballard             Ballard            
##   [88] Ballard             Ballard             Ballard            
##   [91] Ballard             Ballard             Ballard            
##   [94] Ballard             Ballard             Ballard            
##   [97] Ballard             Ballard             Ballard            
##  [100] Ballard             Ballard             Ballard            
##  [103] Ballard             Ballard             Ballard            
##  [106] Ballard             Ballard             Ballard            
##  [109] Ballard             Ballard             Ballard            
##  [112] Ballard             Ballard             Ballard            
##  [115] Ballard             Ballard             Ballard            
##  [118] Ballard             Ballard             Ballard            
##  [121] Ballard             Ballard             Ballard            
##  [124] Ballard             Ballard             Ballard            
##  [127] Ballard             Ballard             Ballard            
##  [130] Ballard             Ballard             Ballard            
##  [133] Ballard             Ballard             Ballard            
##  [136] Ballard             Ballard             Ballard            
##  [139] Ballard             Ballard             Ballard            
##  [142] Ballard             Ballard             Ballard            
##  [145] Ballard             Ballard             Ballard            
##  [148] Ballard             Ballard             Ballard            
##  [151] Ballard             Ballard             Ballard            
##  [154] Ballard             Ballard             Ballard            
##  [157] Ballard             Ballard             Ballard            
##  [160] Ballard             Ballard             Ballard            
##  [163] Ballard             Ballard             Ballard            
##  [166] Ballard             Ballard             Ballard            
##  [169] Ballard             Ballard             Ballard            
##  [172] Ballard             Ballard             Ballard            
##  [175] Ballard             Ballard             Ballard            
##  [178] Ballard             Ballard             Ballard            
##  [181] Ballard             Ballard             Ballard            
##  [184] Ballard             Ballard             Ballard            
##  [187] Ballard             Ballard             Ballard            
##  [190] Ballard             Ballard             Ballard            
##  [193] Ballard             Ballard             Ballard            
##  [196] Ballard             Ballard             Ballard            
##  [199] Ballard             Queen Anne          Queen Anne         
##  [202] Queen Anne          Queen Anne          Queen Anne         
##  [205] Queen Anne          Queen Anne          Queen Anne         
##  [208] Queen Anne          Queen Anne          Queen Anne         
##  [211] Queen Anne          Queen Anne          Queen Anne         
##  [214] Queen Anne          Queen Anne          Queen Anne         
##  [217] Queen Anne          Queen Anne          Queen Anne         
##  [220] Queen Anne          Queen Anne          Queen Anne         
##  [223] Queen Anne          Queen Anne          Queen Anne         
##  [226] Queen Anne          Queen Anne          Queen Anne         
##  [229] Queen Anne          Queen Anne          Queen Anne         
##  [232] Queen Anne          Queen Anne          Queen Anne         
##  [235] Queen Anne          Queen Anne          Queen Anne         
##  [238] Queen Anne          Queen Anne          Queen Anne         
##  [241] Queen Anne          Queen Anne          Queen Anne         
##  [244] Queen Anne          Queen Anne          Queen Anne         
##  [247] Queen Anne          Queen Anne          Queen Anne         
##  [250] Queen Anne          Queen Anne          Queen Anne         
##  [253] Queen Anne          Queen Anne          Queen Anne         
##  [256] Queen Anne          Queen Anne          Queen Anne         
##  [259] Queen Anne          Queen Anne          Queen Anne         
##  [262] Queen Anne          Queen Anne          Queen Anne         
##  [265] Queen Anne          Queen Anne          Queen Anne         
##  [268] Queen Anne          Queen Anne          Queen Anne         
##  [271] Queen Anne          Queen Anne          Queen Anne         
##  [274] Queen Anne          Queen Anne          Queen Anne         
##  [277] Queen Anne          Queen Anne          Queen Anne         
##  [280] Queen Anne          Other neighborhoods Other neighborhoods
##  [283] Other neighborhoods Other neighborhoods Other neighborhoods
##  [286] Other neighborhoods Other neighborhoods Other neighborhoods
##  [289] Other neighborhoods Other neighborhoods Other neighborhoods
##  [292] Other neighborhoods Other neighborhoods Other neighborhoods
##  [295] Other neighborhoods Other neighborhoods Other neighborhoods
##  [298] Other neighborhoods Other neighborhoods Other neighborhoods
##  [301] Other neighborhoods Other neighborhoods Other neighborhoods
##  [304] Other neighborhoods Other neighborhoods Other neighborhoods
##  [307] Other neighborhoods Other neighborhoods Other neighborhoods
##  [310] Other neighborhoods Other neighborhoods Other neighborhoods
##  [313] Other neighborhoods Other neighborhoods Other neighborhoods
##  [316] Other neighborhoods Other neighborhoods Other neighborhoods
##  [319] Other neighborhoods Other neighborhoods Other neighborhoods
##  [322] Other neighborhoods Other neighborhoods Other neighborhoods
##  [325] Other neighborhoods Other neighborhoods Other neighborhoods
##  [328] Other neighborhoods Other neighborhoods Other neighborhoods
##  [331] Other neighborhoods Other neighborhoods Other neighborhoods
##  [334] Other neighborhoods Other neighborhoods Other neighborhoods
##  [337] Other neighborhoods Other neighborhoods Other neighborhoods
##  [340] Other neighborhoods Other neighborhoods Other neighborhoods
##  [343] Other neighborhoods Other neighborhoods Other neighborhoods
##  [346] Other neighborhoods Other neighborhoods Other neighborhoods
##  [349] Other neighborhoods Other neighborhoods Other neighborhoods
##  [352] Other neighborhoods Other neighborhoods Other neighborhoods
##  [355] Other neighborhoods Other neighborhoods Other neighborhoods
##  [358] Other neighborhoods Other neighborhoods Other neighborhoods
##  [361] Other neighborhoods Other neighborhoods Other neighborhoods
##  [364] Other neighborhoods Other neighborhoods Other neighborhoods
##  [367] Other neighborhoods Other neighborhoods Other neighborhoods
##  [370] Other neighborhoods Other neighborhoods Other neighborhoods
##  [373] Other neighborhoods Other neighborhoods Other neighborhoods
##  [376] Other neighborhoods Other neighborhoods Other neighborhoods
##  [379] Other neighborhoods Other neighborhoods Other neighborhoods
##  [382] Other neighborhoods Other neighborhoods Other neighborhoods
##  [385] Other neighborhoods Other neighborhoods Other neighborhoods
##  [388] Other neighborhoods Other neighborhoods Other neighborhoods
##  [391] Other neighborhoods Other neighborhoods Other neighborhoods
##  [394] Other neighborhoods Other neighborhoods Other neighborhoods
##  [397] Other neighborhoods Other neighborhoods Other neighborhoods
##  [400] Other neighborhoods Other neighborhoods Other neighborhoods
##  [403] Other neighborhoods Other neighborhoods Other neighborhoods
##  [406] Other neighborhoods Other neighborhoods Other neighborhoods
##  [409] Other neighborhoods Other neighborhoods Other neighborhoods
##  [412] Other neighborhoods Other neighborhoods Other neighborhoods
##  [415] Other neighborhoods Other neighborhoods Other neighborhoods
##  [418] Other neighborhoods Other neighborhoods Other neighborhoods
##  [421] Other neighborhoods Other neighborhoods Other neighborhoods
##  [424] Other neighborhoods Other neighborhoods Other neighborhoods
##  [427] Other neighborhoods Other neighborhoods Other neighborhoods
##  [430] Other neighborhoods Other neighborhoods Other neighborhoods
##  [433] Other neighborhoods Other neighborhoods Other neighborhoods
##  [436] Other neighborhoods Other neighborhoods Other neighborhoods
##  [439] Other neighborhoods Other neighborhoods Other neighborhoods
##  [442] Other neighborhoods Other neighborhoods Other neighborhoods
##  [445] Other neighborhoods Other neighborhoods Other neighborhoods
##  [448] Queen Anne          Queen Anne          Queen Anne         
##  [451] Queen Anne          Queen Anne          Queen Anne         
##  [454] Queen Anne          Queen Anne          Queen Anne         
##  [457] Queen Anne          Queen Anne          Queen Anne         
##  [460] Queen Anne          Queen Anne          Queen Anne         
##  [463] Queen Anne          Queen Anne          Queen Anne         
##  [466] Queen Anne          Queen Anne          Queen Anne         
##  [469] Queen Anne          Queen Anne          Queen Anne         
##  [472] Queen Anne          Queen Anne          Queen Anne         
##  [475] Queen Anne          Queen Anne          Queen Anne         
##  [478] Queen Anne          Queen Anne          Queen Anne         
##  [481] Queen Anne          Queen Anne          Queen Anne         
##  [484] Queen Anne          Queen Anne          Queen Anne         
##  [487] Queen Anne          Queen Anne          Queen Anne         
##  [490] Queen Anne          Queen Anne          Queen Anne         
##  [493] Queen Anne          Queen Anne          Queen Anne         
##  [496] Queen Anne          Queen Anne          Queen Anne         
##  [499] Queen Anne          Queen Anne          Queen Anne         
##  [502] Other neighborhoods Other neighborhoods Other neighborhoods
##  [505] Other neighborhoods Other neighborhoods Other neighborhoods
##  [508] Other neighborhoods Other neighborhoods Other neighborhoods
##  [511] Other neighborhoods Other neighborhoods Other neighborhoods
##  [514] Other neighborhoods Other neighborhoods Other neighborhoods
##  [517] Other neighborhoods Other neighborhoods Other neighborhoods
##  [520] Other neighborhoods Other neighborhoods Other neighborhoods
##  [523] Other neighborhoods Other neighborhoods Other neighborhoods
##  [526] Other neighborhoods Other neighborhoods Other neighborhoods
##  [529] Other neighborhoods Other neighborhoods Other neighborhoods
##  [532] Other neighborhoods Other neighborhoods Other neighborhoods
##  [535] Other neighborhoods Other neighborhoods Other neighborhoods
##  [538] Other neighborhoods Other neighborhoods Other neighborhoods
##  [541] Other neighborhoods Other neighborhoods Other neighborhoods
##  [544] Other neighborhoods Other neighborhoods Other neighborhoods
##  [547] Other neighborhoods Other neighborhoods Other neighborhoods
##  [550] Other neighborhoods Other neighborhoods Other neighborhoods
##  [553] Other neighborhoods Other neighborhoods Other neighborhoods
##  [556] Cascade             Cascade             Cascade            
##  [559] Cascade             Cascade             Cascade            
##  [562] Cascade             Cascade             Cascade            
##  [565] Cascade             Cascade             Cascade            
##  [568] Cascade             Cascade             Cascade            
##  [571] Cascade             Cascade             Central Area       
##  [574] Central Area        Central Area        Central Area       
##  [577] Central Area        Central Area        Central Area       
##  [580] Central Area        Central Area        Central Area       
##  [583] Central Area        Central Area        Central Area       
##  [586] Central Area        Central Area        Central Area       
##  [589] Central Area        Central Area        Central Area       
##  [592] Central Area        Central Area        Central Area       
##  [595] Central Area        Central Area        Central Area       
##  [598] Central Area        Central Area        Central Area       
##  [601] Central Area        Central Area        Central Area       
##  [604] Central Area        Central Area        Central Area       
##  [607] Central Area        Central Area        Central Area       
##  [610] Central Area        Central Area        Central Area       
##  [613] Central Area        Central Area        Central Area       
##  [616] Central Area        Central Area        Central Area       
##  [619] Central Area        Central Area        Central Area       
##  [622] Central Area        Central Area        Central Area       
##  [625] Central Area        Central Area        Central Area       
##  [628] Central Area        Central Area        Central Area       
##  [631] Central Area        Central Area        Central Area       
##  [634] Central Area        Central Area        Central Area       
##  [637] Central Area        Central Area        Central Area       
##  [640] Central Area        Central Area        Central Area       
##  [643] Central Area        Central Area        Central Area       
##  [646] Central Area        Central Area        Central Area       
##  [649] Central Area        Central Area        Central Area       
##  [652] Central Area        Central Area        Central Area       
##  [655] Central Area        Central Area        Central Area       
##  [658] Central Area        Central Area        Central Area       
##  [661] Central Area        Central Area        Central Area       
##  [664] Central Area        Central Area        Central Area       
##  [667] Central Area        Central Area        Central Area       
##  [670] Central Area        Central Area        Central Area       
##  [673] Central Area        Central Area        Central Area       
##  [676] Central Area        Central Area        Central Area       
##  [679] Central Area        Central Area        Central Area       
##  [682] Central Area        Central Area        Central Area       
##  [685] Central Area        Central Area        University District
##  [688] University District University District University District
##  [691] University District University District University District
##  [694] University District University District University District
##  [697] University District University District University District
##  [700] University District University District University District
##  [703] University District University District University District
##  [706] University District University District University District
##  [709] University District University District University District
##  [712] University District University District University District
##  [715] University District University District University District
##  [718] University District University District University District
##  [721] University District University District University District
##  [724] University District University District University District
##  [727] University District University District University District
##  [730] University District University District University District
##  [733] University District University District University District
##  [736] University District University District University District
##  [739] University District University District University District
##  [742] University District University District University District
##  [745] University District University District University District
##  [748] University District University District University District
##  [751] University District University District University District
##  [754] University District University District University District
##  [757] University District University District University District
##  [760] University District University District University District
##  [763] University District University District University District
##  [766] University District University District University District
##  [769] University District University District University District
##  [772] University District University District University District
##  [775] University District University District University District
##  [778] University District University District University District
##  [781] University District University District University District
##  [784] University District University District University District
##  [787] University District University District University District
##  [790] University District University District University District
##  [793] University District University District University District
##  [796] University District University District University District
##  [799] University District University District University District
##  [802] University District University District University District
##  [805] University District University District University District
##  [808] University District Central Area        Central Area       
##  [811] Central Area        Central Area        Central Area       
##  [814] Central Area        Central Area        Central Area       
##  [817] Central Area        Central Area        Central Area       
##  [820] Central Area        Central Area        Central Area       
##  [823] Central Area        Central Area        Central Area       
##  [826] Central Area        Central Area        Central Area       
##  [829] Central Area        Central Area        Central Area       
##  [832] Central Area        Central Area        Central Area       
##  [835] Central Area        Central Area        Central Area       
##  [838] Central Area        Central Area        Central Area       
##  [841] Central Area        Central Area        Central Area       
##  [844] Central Area        Central Area        Central Area       
##  [847] Central Area        Central Area        Central Area       
##  [850] Central Area        Central Area        Central Area       
##  [853] Central Area        Central Area        Central Area       
##  [856] Central Area        Central Area        Central Area       
##  [859] Central Area        Central Area        Central Area       
##  [862] Central Area        Central Area        Central Area       
##  [865] Central Area        Central Area        Central Area       
##  [868] Central Area        Central Area        Central Area       
##  [871] Central Area        Central Area        Central Area       
##  [874] Central Area        Central Area        Central Area       
##  [877] Central Area        Central Area        Central Area       
##  [880] Central Area        Central Area        Central Area       
##  [883] Central Area        Central Area        Central Area       
##  [886] Central Area        Central Area        Central Area       
##  [889] Central Area        Central Area        Central Area       
##  [892] Central Area        Central Area        Central Area       
##  [895] Central Area        Central Area        Central Area       
##  [898] Central Area        Central Area        Central Area       
##  [901] Central Area        Central Area        Central Area       
##  [904] Central Area        Central Area        Central Area       
##  [907] Central Area        Central Area        Central Area       
##  [910] Central Area        Central Area        Central Area       
##  [913] Central Area        Central Area        Central Area       
##  [916] Central Area        Central Area        Central Area       
##  [919] Central Area        Central Area        Central Area       
##  [922] Central Area        Central Area        Central Area       
##  [925] Central Area        Central Area        Central Area       
##  [928] Central Area        Central Area        Central Area       
##  [931] Central Area        Central Area        Central Area       
##  [934] Central Area        Central Area        Central Area       
##  [937] Central Area        Central Area        Central Area       
##  [940] Central Area        Central Area        Central Area       
##  [943] Central Area        Central Area        Central Area       
##  [946] Central Area        Central Area        Central Area       
##  [949] Central Area        Central Area        Central Area       
##  [952] Central Area        Central Area        Central Area       
##  [955] Central Area        Central Area        Central Area       
##  [958] Central Area        Central Area        Central Area       
##  [961] Central Area        Central Area        Central Area       
##  [964] Central Area        Central Area        Central Area       
##  [967] Central Area        Central Area        Central Area       
##  [970] Central Area        Central Area        Central Area       
##  [973] Central Area        Central Area        Central Area       
##  [976] Central Area        Central Area        Central Area       
##  [979] Central Area        Central Area        Central Area       
##  [982] Central Area        Central Area        Central Area       
##  [985] Central Area        Central Area        Central Area       
##  [988] Central Area        Central Area        Central Area       
##  [991] Central Area        Central Area        Central Area       
##  [994] Central Area        Central Area        Central Area       
##  [997] Central Area        Central Area        Central Area       
## [1000] Central Area        Central Area        Central Area       
## [1003] Central Area        Central Area        Central Area       
## [1006] Central Area        Central Area        Central Area       
## [1009] Central Area        Central Area        Central Area       
## [1012] Central Area        Central Area        Central Area       
## [1015] Central Area        Central Area        Central Area       
## [1018] Central Area        Central Area        Central Area       
## [1021] Central Area        Central Area        Central Area       
## [1024] Central Area        Central Area        Central Area       
## [1027] Central Area        Central Area        Central Area       
## [1030] Central Area        Central Area        Central Area       
## [1033] Central Area        Central Area        Central Area       
## [1036] Central Area        Central Area        Central Area       
## [1039] Central Area        Central Area        Central Area       
## [1042] Central Area        Central Area        Central Area       
## [1045] Central Area        Central Area        Central Area       
## [1048] Central Area        Central Area        Central Area       
## [1051] Central Area        Central Area        Central Area       
## [1054] Central Area        Central Area        Central Area       
## [1057] Central Area        Central Area        Central Area       
## [1060] Central Area        Central Area        Central Area       
## [1063] Central Area        Downtown            Downtown           
## [1066] Downtown            Downtown            Downtown           
## [1069] Downtown            Downtown            Downtown           
## [1072] Downtown            Downtown            Downtown           
## [1075] Downtown            Downtown            Downtown           
## [1078] Downtown            Downtown            Downtown           
## [1081] Downtown            Downtown            Downtown           
## [1084] Downtown            Downtown            Downtown           
## [1087] Downtown            Downtown            Downtown           
## [1090] Downtown            Downtown            Cascade            
## [1093] Cascade             Cascade             Cascade            
## [1096] Cascade             Cascade             Cascade            
## [1099] Cascade             Cascade             Cascade            
## [1102] Cascade             Cascade             Cascade            
## [1105] Cascade             Cascade             Cascade            
## [1108] Cascade             Cascade             Cascade            
## [1111] Cascade             Cascade             Cascade            
## [1114] Cascade             Cascade             Cascade            
## [1117] Cascade             Cascade             Cascade            
## [1120] Cascade             Cascade             Cascade            
## [1123] Cascade             Cascade             Cascade            
## [1126] Cascade             Cascade             Cascade            
## [1129] Cascade             Cascade             Cascade            
## [1132] Cascade             Cascade             Cascade            
## [1135] Cascade             Cascade             Cascade            
## [1138] Cascade             Cascade             Cascade            
## [1141] Cascade             Cascade             Cascade            
## [1144] Cascade             Cascade             Cascade            
## [1147] Cascade             Cascade             Cascade            
## [1150] Cascade             Cascade             Cascade            
## [1153] Cascade             Cascade             Cascade            
## [1156] Cascade             Cascade             Cascade            
## [1159] Cascade             Cascade             Cascade            
## [1162] Cascade             Cascade             Magnolia           
## [1165] Magnolia            Magnolia            Magnolia           
## [1168] Magnolia            Magnolia            Magnolia           
## [1171] Magnolia            Magnolia            Magnolia           
## [1174] Magnolia            Magnolia            Magnolia           
## [1177] Magnolia            Magnolia            Magnolia           
## [1180] Magnolia            Magnolia            Magnolia           
## [1183] Magnolia            Magnolia            Magnolia           
## [1186] Magnolia            Magnolia            Magnolia           
## [1189] Magnolia            Magnolia            Magnolia           
## [1192] Magnolia            Magnolia            Magnolia           
## [1195] Magnolia            Magnolia            Magnolia           
## [1198] Magnolia            Magnolia            Magnolia           
## [1201] Magnolia            Magnolia            Magnolia           
## [1204] Magnolia            Magnolia            Magnolia           
## [1207] Magnolia            Downtown            Downtown           
## [1210] Downtown            Downtown            Downtown           
## [1213] Downtown            Downtown            Downtown           
## [1216] Downtown            Downtown            Downtown           
## [1219] Downtown            Downtown            Downtown           
## [1222] Downtown            Downtown            Downtown           
## [1225] Downtown            Downtown            Downtown           
## [1228] Downtown            Downtown            Downtown           
## [1231] Downtown            Downtown            Downtown           
## [1234] Downtown            Downtown            Downtown           
## [1237] Downtown            Downtown            Downtown           
## [1240] Downtown            Downtown            Downtown           
## [1243] Downtown            Downtown            Downtown           
## [1246] Downtown            Downtown            Downtown           
## [1249] Downtown            Downtown            Downtown           
## [1252] Downtown            Downtown            Downtown           
## [1255] Downtown            Downtown            Downtown           
## [1258] Downtown            Downtown            Downtown           
## [1261] Downtown            Downtown            Downtown           
## [1264] Downtown            Downtown            Downtown           
## [1267] Downtown            Downtown            Downtown           
## [1270] Downtown            Downtown            Downtown           
## [1273] Downtown            Downtown            Downtown           
## [1276] Downtown            Downtown            Downtown           
## [1279] Downtown            Downtown            Downtown           
## [1282] Downtown            Downtown            Downtown           
## [1285] Downtown            Downtown            Downtown           
## [1288] Downtown            Downtown            Downtown           
## [1291] Downtown            Downtown            Downtown           
## [1294] Downtown            Downtown            Downtown           
## [1297] Downtown            Downtown            Downtown           
## [1300] Downtown            Downtown            Downtown           
## [1303] Downtown            Downtown            Downtown           
## [1306] Downtown            Downtown            Downtown           
## [1309] Downtown            Downtown            Downtown           
## [1312] Downtown            Downtown            Downtown           
## [1315] Downtown            Downtown            Downtown           
## [1318] Downtown            Downtown            Downtown           
## [1321] Downtown            Downtown            Downtown           
## [1324] Downtown            Downtown            Downtown           
## [1327] Downtown            Downtown            Downtown           
## [1330] Downtown            Downtown            Downtown           
## [1333] Downtown            Downtown            Downtown           
## [1336] Downtown            Downtown            Downtown           
## [1339] Downtown            Downtown            Downtown           
## [1342] Downtown            Downtown            Downtown           
## [1345] Downtown            Downtown            Downtown           
## [1348] Downtown            Downtown            Downtown           
## [1351] Downtown            Downtown            Downtown           
## [1354] Downtown            Downtown            Downtown           
## [1357] Downtown            Downtown            Downtown           
## [1360] Downtown            Downtown            Downtown           
## [1363] Downtown            Downtown            Downtown           
## [1366] Downtown            Downtown            Downtown           
## [1369] Downtown            Downtown            Downtown           
## [1372] Downtown            Downtown            Downtown           
## [1375] Downtown            Downtown            Downtown           
## [1378] Downtown            Downtown            Downtown           
## [1381] Downtown            Downtown            Downtown           
## [1384] Downtown            Downtown            Downtown           
## [1387] Downtown            Downtown            Downtown           
## [1390] Downtown            Downtown            Downtown           
## [1393] Downtown            Downtown            Downtown           
## [1396] Downtown            Downtown            Downtown           
## [1399] Downtown            Downtown            Downtown           
## [1402] Downtown            Downtown            Downtown           
## [1405] Downtown            Downtown            Downtown           
## [1408] Downtown            Downtown            Downtown           
## [1411] Downtown            Downtown            Downtown           
## [1414] Downtown            Downtown            Downtown           
## [1417] Downtown            Downtown            Downtown           
## [1420] Downtown            Downtown            Downtown           
## [1423] Downtown            Downtown            Downtown           
## [1426] Downtown            Downtown            Downtown           
## [1429] Downtown            Downtown            Downtown           
## [1432] Downtown            Downtown            Downtown           
## [1435] Downtown            Downtown            Downtown           
## [1438] Downtown            Downtown            Downtown           
## [1441] Downtown            Downtown            Downtown           
## [1444] Downtown            Downtown            Downtown           
## [1447] Downtown            Downtown            Downtown           
## [1450] Downtown            Downtown            Downtown           
## [1453] Downtown            Downtown            Downtown           
## [1456] Downtown            Downtown            Downtown           
## [1459] Downtown            Downtown            Downtown           
## [1462] Downtown            Downtown            Downtown           
## [1465] Downtown            Downtown            Downtown           
## [1468] Downtown            Downtown            Downtown           
## [1471] Downtown            Downtown            Downtown           
## [1474] Downtown            Downtown            Downtown           
## [1477] Downtown            Downtown            Downtown           
## [1480] Downtown            Downtown            Downtown           
## [1483] Downtown            Downtown            Downtown           
## [1486] Downtown            Downtown            Downtown           
## [1489] Downtown            Downtown            Downtown           
## [1492] Downtown            Downtown            Downtown           
## [1495] Downtown            Downtown            Downtown           
## [1498] Downtown            Downtown            Downtown           
## [1501] Downtown            Downtown            Downtown           
## [1504] Downtown            Downtown            Downtown           
## [1507] Downtown            Downtown            Downtown           
## [1510] Downtown            Downtown            Downtown           
## [1513] Downtown            Downtown            Downtown           
## [1516] Downtown            Downtown            Downtown           
## [1519] Downtown            Downtown            Downtown           
## [1522] Downtown            Downtown            Downtown           
## [1525] Downtown            Downtown            Downtown           
## [1528] Downtown            Downtown            Downtown           
## [1531] Downtown            Downtown            Downtown           
## [1534] Downtown            Downtown            Downtown           
## [1537] Downtown            Downtown            Downtown           
## [1540] Downtown            Downtown            Downtown           
## [1543] Downtown            Downtown            Downtown           
## [1546] Downtown            Downtown            Downtown           
## [1549] Downtown            Downtown            Downtown           
## [1552] Downtown            Downtown            Downtown           
## [1555] Downtown            Downtown            Downtown           
## [1558] Downtown            Downtown            Downtown           
## [1561] Downtown            Downtown            Downtown           
## [1564] Downtown            Downtown            Downtown           
## [1567] Downtown            Downtown            Downtown           
## [1570] Downtown            Downtown            Downtown           
## [1573] Downtown            Downtown            Downtown           
## [1576] Downtown            Downtown            Downtown           
## [1579] Downtown            Downtown            Downtown           
## [1582] Downtown            Downtown            Downtown           
## [1585] Downtown            Downtown            Downtown           
## [1588] Downtown            Downtown            Downtown           
## [1591] Downtown            Downtown            Downtown           
## [1594] Downtown            Downtown            Downtown           
## [1597] Downtown            Downtown            Downtown           
## [1600] Downtown            Downtown            Downtown           
## [1603] Downtown            Downtown            Downtown           
## [1606] Downtown            Downtown            Downtown           
## [1609] Downtown            Downtown            Downtown           
## [1612] Downtown            Downtown            Downtown           
## [1615] Downtown            Downtown            Downtown           
## [1618] Downtown            Downtown            Downtown           
## [1621] Downtown            Downtown            Downtown           
## [1624] Downtown            Downtown            Downtown           
## [1627] Downtown            Downtown            Downtown           
## [1630] Downtown            Downtown            Downtown           
## [1633] Downtown            Downtown            Downtown           
## [1636] Downtown            Downtown            Downtown           
## [1639] Downtown            Downtown            Downtown           
## [1642] Downtown            Downtown            Downtown           
## [1645] Downtown            Downtown            Downtown           
## [1648] Downtown            Downtown            Downtown           
## [1651] Downtown            Downtown            Downtown           
## [1654] Downtown            Downtown            Downtown           
## [1657] Downtown            Downtown            Downtown           
## [1660] Downtown            Downtown            Downtown           
## [1663] Downtown            Downtown            Downtown           
## [1666] Downtown            Downtown            Downtown           
## [1669] Downtown            Downtown            Downtown           
## [1672] Downtown            Downtown            Downtown           
## [1675] Downtown            Downtown            Downtown           
## [1678] Downtown            Downtown            Downtown           
## [1681] Downtown            Downtown            Downtown           
## [1684] Downtown            Downtown            Downtown           
## [1687] Downtown            Downtown            Downtown           
## [1690] Downtown            Downtown            Downtown           
## [1693] Downtown            Downtown            Downtown           
## [1696] Downtown            Downtown            Downtown           
## [1699] Downtown            Downtown            Downtown           
## [1702] Downtown            Downtown            Downtown           
## [1705] Downtown            Downtown            Downtown           
## [1708] Downtown            Downtown            West Seattle       
## [1711] West Seattle        West Seattle        West Seattle       
## [1714] West Seattle        West Seattle        West Seattle       
## [1717] West Seattle        West Seattle        West Seattle       
## [1720] West Seattle        West Seattle        West Seattle       
## [1723] West Seattle        West Seattle        West Seattle       
## [1726] West Seattle        West Seattle        West Seattle       
## [1729] West Seattle        West Seattle        West Seattle       
## [1732] West Seattle        West Seattle        West Seattle       
## [1735] West Seattle        West Seattle        West Seattle       
## [1738] West Seattle        West Seattle        West Seattle       
## [1741] West Seattle        West Seattle        West Seattle       
## [1744] West Seattle        West Seattle        West Seattle       
## [1747] West Seattle        West Seattle        West Seattle       
## [1750] West Seattle        West Seattle        West Seattle       
## [1753] West Seattle        West Seattle        West Seattle       
## [1756] West Seattle        West Seattle        West Seattle       
## [1759] West Seattle        West Seattle        West Seattle       
## [1762] West Seattle        West Seattle        West Seattle       
## [1765] West Seattle        West Seattle        West Seattle       
## [1768] West Seattle        West Seattle        West Seattle       
## [1771] West Seattle        West Seattle        West Seattle       
## [1774] West Seattle        West Seattle        West Seattle       
## [1777] West Seattle        West Seattle        West Seattle       
## [1780] West Seattle        West Seattle        West Seattle       
## [1783] West Seattle        West Seattle        West Seattle       
## [1786] West Seattle        West Seattle        West Seattle       
## [1789] West Seattle        West Seattle        West Seattle       
## [1792] West Seattle        West Seattle        West Seattle       
## [1795] West Seattle        West Seattle        West Seattle       
## [1798] West Seattle        West Seattle        West Seattle       
## [1801] West Seattle        West Seattle        West Seattle       
## [1804] West Seattle        West Seattle        West Seattle       
## [1807] West Seattle        West Seattle        West Seattle       
## [1810] West Seattle        West Seattle        West Seattle       
## [1813] West Seattle        West Seattle        West Seattle       
## [1816] West Seattle        West Seattle        West Seattle       
## [1819] West Seattle        West Seattle        West Seattle       
## [1822] West Seattle        West Seattle        West Seattle       
## [1825] West Seattle        West Seattle        West Seattle       
## [1828] Other neighborhoods Other neighborhoods Other neighborhoods
## [1831] Other neighborhoods Other neighborhoods Other neighborhoods
## [1834] Other neighborhoods Other neighborhoods Other neighborhoods
## [1837] Other neighborhoods Other neighborhoods Other neighborhoods
## [1840] Other neighborhoods Other neighborhoods Other neighborhoods
## [1843] Other neighborhoods Other neighborhoods Other neighborhoods
## [1846] Other neighborhoods Other neighborhoods Other neighborhoods
## [1849] West Seattle        West Seattle        West Seattle       
## [1852] West Seattle        West Seattle        West Seattle       
## [1855] West Seattle        West Seattle        West Seattle       
## [1858] West Seattle        West Seattle        West Seattle       
## [1861] West Seattle        West Seattle        West Seattle       
## [1864] West Seattle        West Seattle        West Seattle       
## [1867] West Seattle        West Seattle        West Seattle       
## [1870] West Seattle        West Seattle        West Seattle       
## [1873] West Seattle        West Seattle        West Seattle       
## [1876] West Seattle        West Seattle        West Seattle       
## [1879] West Seattle        West Seattle        West Seattle       
## [1882] West Seattle        West Seattle        West Seattle       
## [1885] West Seattle        West Seattle        West Seattle       
## [1888] West Seattle        West Seattle        West Seattle       
## [1891] West Seattle        West Seattle        West Seattle       
## [1894] West Seattle        West Seattle        West Seattle       
## [1897] West Seattle        West Seattle        West Seattle       
## [1900] West Seattle        West Seattle        West Seattle       
## [1903] West Seattle        West Seattle        West Seattle       
## [1906] West Seattle        West Seattle        West Seattle       
## [1909] West Seattle        West Seattle        West Seattle       
## [1912] Interbay            Interbay            Interbay           
## [1915] Interbay            Interbay            Interbay           
## [1918] Interbay            Interbay            Interbay           
## [1921] Interbay            Interbay            Other neighborhoods
## [1924] Other neighborhoods Other neighborhoods Other neighborhoods
## [1927] Other neighborhoods Beacon Hill         Beacon Hill        
## [1930] Beacon Hill         Beacon Hill         Beacon Hill        
## [1933] Beacon Hill         Beacon Hill         Beacon Hill        
## [1936] Beacon Hill         Beacon Hill         Beacon Hill        
## [1939] Beacon Hill         Beacon Hill         Beacon Hill        
## [1942] Beacon Hill         Beacon Hill         Beacon Hill        
## [1945] Beacon Hill         Beacon Hill         Beacon Hill        
## [1948] Beacon Hill         Beacon Hill         Beacon Hill        
## [1951] Beacon Hill         Beacon Hill         Beacon Hill        
## [1954] Beacon Hill         Beacon Hill         Beacon Hill        
## [1957] Beacon Hill         Beacon Hill         Beacon Hill        
## [1960] Beacon Hill         Beacon Hill         Other neighborhoods
## [1963] Other neighborhoods Other neighborhoods Other neighborhoods
## [1966] Other neighborhoods Other neighborhoods Other neighborhoods
## [1969] Other neighborhoods Other neighborhoods Other neighborhoods
## [1972] Other neighborhoods Other neighborhoods Other neighborhoods
## [1975] Other neighborhoods Other neighborhoods Other neighborhoods
## [1978] Other neighborhoods Other neighborhoods Other neighborhoods
## [1981] Other neighborhoods Other neighborhoods Other neighborhoods
## [1984] Other neighborhoods Other neighborhoods Other neighborhoods
## [1987] Other neighborhoods Other neighborhoods Other neighborhoods
## [1990] Other neighborhoods Other neighborhoods Other neighborhoods
## [1993] Other neighborhoods Other neighborhoods Other neighborhoods
## [1996] Other neighborhoods Other neighborhoods Other neighborhoods
## [1999] Other neighborhoods Other neighborhoods Other neighborhoods
## [2002] Other neighborhoods Other neighborhoods Other neighborhoods
## [2005] Other neighborhoods Other neighborhoods Other neighborhoods
## [2008] Other neighborhoods Other neighborhoods Other neighborhoods
## [2011] Other neighborhoods Other neighborhoods Other neighborhoods
## [2014] Other neighborhoods Other neighborhoods Other neighborhoods
## [2017] Other neighborhoods Other neighborhoods Other neighborhoods
## [2020] Other neighborhoods Other neighborhoods Other neighborhoods
## [2023] Other neighborhoods Other neighborhoods Other neighborhoods
## [2026] Other neighborhoods Other neighborhoods Other neighborhoods
## [2029] Other neighborhoods Other neighborhoods Other neighborhoods
## [2032] Other neighborhoods Other neighborhoods Other neighborhoods
## [2035] Other neighborhoods Other neighborhoods Other neighborhoods
## [2038] Other neighborhoods Other neighborhoods Other neighborhoods
## [2041] Other neighborhoods Other neighborhoods Other neighborhoods
## [2044] Other neighborhoods Other neighborhoods Other neighborhoods
## [2047] Other neighborhoods Other neighborhoods Other neighborhoods
## [2050] Other neighborhoods Beacon Hill         Beacon Hill        
## [2053] Beacon Hill         Beacon Hill         Beacon Hill        
## [2056] Beacon Hill         West Seattle        West Seattle       
## [2059] West Seattle        West Seattle        West Seattle       
## [2062] West Seattle        West Seattle        West Seattle       
## [2065] West Seattle        West Seattle        Beacon Hill        
## [2068] Beacon Hill         Beacon Hill         Beacon Hill        
## [2071] Beacon Hill         Beacon Hill         Beacon Hill        
## [2074] Beacon Hill         Beacon Hill         Beacon Hill        
## [2077] Beacon Hill         Beacon Hill         Beacon Hill        
## [2080] Beacon Hill         Beacon Hill         Beacon Hill        
## [2083] Beacon Hill         Beacon Hill         Beacon Hill        
## [2086] Beacon Hill         Beacon Hill         Beacon Hill        
## [2089] Beacon Hill         Beacon Hill         Beacon Hill        
## [2092] Beacon Hill         Beacon Hill         Beacon Hill        
## [2095] Beacon Hill         Beacon Hill         Beacon Hill        
## [2098] Beacon Hill         Beacon Hill         Beacon Hill        
## [2101] Beacon Hill         Beacon Hill         Beacon Hill        
## [2104] Beacon Hill         Beacon Hill         Beacon Hill        
## [2107] Beacon Hill         Beacon Hill         Beacon Hill        
## [2110] Beacon Hill         Beacon Hill         Beacon Hill        
## [2113] Beacon Hill         Beacon Hill         Beacon Hill        
## [2116] Beacon Hill         Beacon Hill         Beacon Hill        
## [2119] Beacon Hill         Beacon Hill         Beacon Hill        
## [2122] Beacon Hill         Beacon Hill         Beacon Hill        
## [2125] Beacon Hill         Beacon Hill         Beacon Hill        
## [2128] Beacon Hill         Beacon Hill         Beacon Hill        
## [2131] Beacon Hill         Beacon Hill         Beacon Hill        
## [2134] Beacon Hill         Beacon Hill         Beacon Hill        
## [2137] Beacon Hill         Rainier Valley      Beacon Hill        
## [2140] Beacon Hill         Beacon Hill         Beacon Hill        
## [2143] Beacon Hill         Beacon Hill         Beacon Hill        
## [2146] Rainier Valley      Rainier Valley      Rainier Valley     
## [2149] Rainier Valley      Rainier Valley      Rainier Valley     
## [2152] Rainier Valley      Rainier Valley      Rainier Valley     
## [2155] Rainier Valley      Rainier Valley      Rainier Valley     
## [2158] Rainier Valley      Delridge            Delridge           
## [2161] Delridge            Delridge            Delridge           
## [2164] Delridge            Delridge            Delridge           
## [2167] Delridge            Delridge            Delridge           
## [2170] Delridge            Other neighborhoods Other neighborhoods
## [2173] Other neighborhoods Other neighborhoods Other neighborhoods
## [2176] Other neighborhoods Other neighborhoods Rainier Valley     
## [2179] Rainier Valley      Rainier Valley      Rainier Valley     
## [2182] Rainier Valley      Rainier Valley      Rainier Valley     
## [2185] Rainier Valley      Rainier Valley      Rainier Valley     
## [2188] Rainier Valley      Rainier Valley      Rainier Valley     
## [2191] Rainier Valley      Rainier Valley      Rainier Valley     
## [2194] Rainier Valley      Rainier Valley      Rainier Valley     
## [2197] Rainier Valley      Rainier Valley      Rainier Valley     
## [2200] Rainier Valley      Rainier Valley      Rainier Valley     
## [2203] Rainier Valley      Rainier Valley      Rainier Valley     
## [2206] Rainier Valley      Rainier Valley      Rainier Valley     
## [2209] Rainier Valley      Rainier Valley      Rainier Valley     
## [2212] Rainier Valley      Rainier Valley      Rainier Valley     
## [2215] Rainier Valley      Rainier Valley      Rainier Valley     
## [2218] Rainier Valley      Rainier Valley      Rainier Valley     
## [2221] Rainier Valley      Rainier Valley      Rainier Valley     
## [2224] Rainier Valley      Rainier Valley      Rainier Valley     
## [2227] Rainier Valley      Rainier Valley      Rainier Valley     
## [2230] Rainier Valley      Rainier Valley      Rainier Valley     
## [2233] Rainier Valley      Rainier Valley      Rainier Valley     
## [2236] Rainier Valley      Rainier Valley      Rainier Valley     
## [2239] Rainier Valley      Rainier Valley      Rainier Valley     
## [2242] Rainier Valley      Rainier Valley      Rainier Valley     
## [2245] Rainier Valley      Rainier Valley      Rainier Valley     
## [2248] Rainier Valley      Rainier Valley      Rainier Valley     
## [2251] Rainier Valley      Rainier Valley      Rainier Valley     
## [2254] Rainier Valley      Rainier Valley      Rainier Valley     
## [2257] Rainier Valley      Rainier Valley      Rainier Valley     
## [2260] Rainier Valley      Rainier Valley      Rainier Valley     
## [2263] Rainier Valley      Rainier Valley      Rainier Valley     
## [2266] Rainier Valley      Rainier Valley      Rainier Valley     
## [2269] Rainier Valley      Rainier Valley      Rainier Valley     
## [2272] Rainier Valley      Rainier Valley      Rainier Valley     
## [2275] Rainier Valley      Rainier Valley      Rainier Valley     
## [2278] Rainier Valley      Rainier Valley      Rainier Valley     
## [2281] Rainier Valley      Rainier Valley      Rainier Valley     
## [2284] Rainier Valley      Rainier Valley      Rainier Valley     
## [2287] Rainier Valley      Rainier Valley      Rainier Valley     
## [2290] Rainier Valley      Rainier Valley      Rainier Valley     
## [2293] Rainier Valley      Rainier Valley      Rainier Valley     
## [2296] Rainier Valley      Rainier Valley      Rainier Valley     
## [2299] Rainier Valley      Rainier Valley      Rainier Valley     
## [2302] Rainier Valley      Rainier Valley      Rainier Valley     
## [2305] Rainier Valley      Rainier Valley      Rainier Valley     
## [2308] Rainier Valley      Rainier Valley      Rainier Valley     
## [2311] Rainier Valley      Rainier Valley      Rainier Valley     
## [2314] Rainier Valley      Rainier Valley      Rainier Valley     
## [2317] Rainier Valley      Rainier Valley      Rainier Valley     
## [2320] Rainier Valley      Rainier Valley      Seward Park        
## [2323] Seward Park         Seward Park         Seward Park        
## [2326] Seward Park         Seward Park         Seward Park        
## [2329] Seward Park         Seward Park         Seward Park        
## [2332] Seward Park         Seward Park         Seward Park        
## [2335] Seward Park         Seward Park         Seward Park        
## [2338] Seward Park         Seward Park         Seward Park        
## [2341] Seward Park         Seward Park         Seward Park        
## [2344] Seward Park         Seward Park         Seward Park        
## [2347] Seward Park         Seward Park         Seward Park        
## [2350] Seward Park         Seward Park         Seward Park        
## [2353] Seward Park         Seward Park         Seward Park        
## [2356] Seward Park         Seward Park         Seward Park        
## [2359] Seward Park         Seward Park         Seward Park        
## [2362] Seward Park         Seward Park         Seward Park        
## [2365] Seward Park         Delridge            Delridge           
## [2368] Delridge            Delridge            Delridge           
## [2371] Delridge            Delridge            Delridge           
## [2374] Delridge            Delridge            Delridge           
## [2377] Delridge            Delridge            Delridge           
## [2380] Delridge            Delridge            Delridge           
## [2383] Delridge            Delridge            Delridge           
## [2386] Delridge            Delridge            Delridge           
## [2389] Delridge            Delridge            Delridge           
## [2392] Delridge            Delridge            Delridge           
## [2395] Delridge            Delridge            Delridge           
## [2398] Northgate           Northgate           Northgate          
## [2401] Northgate           Northgate           Northgate          
## [2404] Northgate           Northgate           Northgate          
## [2407] Northgate           Northgate           Northgate          
## [2410] Northgate           Northgate           Northgate          
## [2413] Northgate           Northgate           Northgate          
## [2416] Northgate           Northgate           Northgate          
## [2419] Northgate           Northgate           Northgate          
## [2422] Northgate           Northgate           Northgate          
## [2425] Northgate           Northgate           Northgate          
## [2428] Northgate           Northgate           Northgate          
## [2431] Northgate           Northgate           Northgate          
## [2434] Northgate           Northgate           Northgate          
## [2437] Northgate           Northgate           Northgate          
## [2440] Other neighborhoods Other neighborhoods Other neighborhoods
## [2443] Other neighborhoods Other neighborhoods Other neighborhoods
## [2446] Other neighborhoods Other neighborhoods Other neighborhoods
## [2449] Other neighborhoods Other neighborhoods Other neighborhoods
## [2452] Other neighborhoods Other neighborhoods Other neighborhoods
## [2455] Other neighborhoods Other neighborhoods Other neighborhoods
## [2458] Other neighborhoods Other neighborhoods Other neighborhoods
## [2461] Other neighborhoods Other neighborhoods Other neighborhoods
## [2464] Other neighborhoods Other neighborhoods Other neighborhoods
## [2467] Other neighborhoods Other neighborhoods Other neighborhoods
## [2470] Other neighborhoods Other neighborhoods Other neighborhoods
## [2473] Other neighborhoods Other neighborhoods Other neighborhoods
## [2476] Other neighborhoods Other neighborhoods Other neighborhoods
## [2479] Other neighborhoods Other neighborhoods Other neighborhoods
## [2482] Other neighborhoods Other neighborhoods Other neighborhoods
## [2485] Other neighborhoods Other neighborhoods Other neighborhoods
## [2488] Other neighborhoods Other neighborhoods Other neighborhoods
## [2491] Other neighborhoods Other neighborhoods Other neighborhoods
## [2494] Other neighborhoods Other neighborhoods Other neighborhoods
## [2497] Other neighborhoods Other neighborhoods Other neighborhoods
## [2500] Other neighborhoods Other neighborhoods Other neighborhoods
## [2503] Other neighborhoods Other neighborhoods Other neighborhoods
## [2506] Other neighborhoods Delridge            Delridge           
## [2509] Delridge            Delridge            Delridge           
## [2512] Delridge            Delridge            Delridge           
## [2515] Capitol Hill        Capitol Hill        Capitol Hill       
## [2518] Capitol Hill        Capitol Hill        Capitol Hill       
## [2521] Capitol Hill        Capitol Hill        Capitol Hill       
## [2524] Capitol Hill        Capitol Hill        Capitol Hill       
## [2527] Capitol Hill        Other neighborhoods Other neighborhoods
## [2530] Other neighborhoods Other neighborhoods Other neighborhoods
## [2533] Other neighborhoods Other neighborhoods Other neighborhoods
## [2536] Other neighborhoods Other neighborhoods Other neighborhoods
## [2539] Other neighborhoods Other neighborhoods Other neighborhoods
## [2542] Other neighborhoods Other neighborhoods Other neighborhoods
## [2545] Other neighborhoods Other neighborhoods Other neighborhoods
## [2548] Other neighborhoods Other neighborhoods Other neighborhoods
## [2551] Other neighborhoods Other neighborhoods Other neighborhoods
## [2554] Other neighborhoods Other neighborhoods Other neighborhoods
## [2557] Capitol Hill        Capitol Hill        Capitol Hill       
## [2560] Capitol Hill        Capitol Hill        Capitol Hill       
## [2563] Capitol Hill        Capitol Hill        Capitol Hill       
## [2566] Capitol Hill        Capitol Hill        Capitol Hill       
## [2569] Capitol Hill        Capitol Hill        Capitol Hill       
## [2572] Capitol Hill        Capitol Hill        Capitol Hill       
## [2575] Capitol Hill        Capitol Hill        Capitol Hill       
## [2578] Capitol Hill        Capitol Hill        Capitol Hill       
## [2581] Capitol Hill        Capitol Hill        Capitol Hill       
## [2584] Capitol Hill        Capitol Hill        Capitol Hill       
## [2587] Capitol Hill        Capitol Hill        Capitol Hill       
## [2590] Capitol Hill        Capitol Hill        Capitol Hill       
## [2593] Capitol Hill        Capitol Hill        Capitol Hill       
## [2596] Capitol Hill        Capitol Hill        Capitol Hill       
## [2599] Capitol Hill        Capitol Hill        Capitol Hill       
## [2602] Capitol Hill        Capitol Hill        Capitol Hill       
## [2605] Capitol Hill        Capitol Hill        Capitol Hill       
## [2608] Capitol Hill        Capitol Hill        Capitol Hill       
## [2611] Capitol Hill        Capitol Hill        Capitol Hill       
## [2614] Capitol Hill        Capitol Hill        Capitol Hill       
## [2617] Capitol Hill        Capitol Hill        Capitol Hill       
## [2620] Capitol Hill        Capitol Hill        Capitol Hill       
## [2623] Capitol Hill        Capitol Hill        Capitol Hill       
## [2626] Capitol Hill        Capitol Hill        Capitol Hill       
## [2629] Capitol Hill        Capitol Hill        Capitol Hill       
## [2632] Capitol Hill        Capitol Hill        Capitol Hill       
## [2635] Capitol Hill        Capitol Hill        Capitol Hill       
## [2638] Capitol Hill        Capitol Hill        Capitol Hill       
## [2641] Capitol Hill        Capitol Hill        Capitol Hill       
## [2644] Capitol Hill        Capitol Hill        Capitol Hill       
## [2647] Capitol Hill        Capitol Hill        Capitol Hill       
## [2650] Capitol Hill        Capitol Hill        Capitol Hill       
## [2653] Capitol Hill        Capitol Hill        Capitol Hill       
## [2656] Capitol Hill        Capitol Hill        Capitol Hill       
## [2659] Capitol Hill        Capitol Hill        Capitol Hill       
## [2662] Capitol Hill        Capitol Hill        Capitol Hill       
## [2665] Capitol Hill        Capitol Hill        Capitol Hill       
## [2668] Capitol Hill        Capitol Hill        Capitol Hill       
## [2671] Capitol Hill        Capitol Hill        Capitol Hill       
## [2674] Capitol Hill        Capitol Hill        Capitol Hill       
## [2677] Capitol Hill        Capitol Hill        Capitol Hill       
## [2680] Capitol Hill        Capitol Hill        Capitol Hill       
## [2683] Capitol Hill        Capitol Hill        Capitol Hill       
## [2686] Capitol Hill        Capitol Hill        Capitol Hill       
## [2689] Capitol Hill        Capitol Hill        Capitol Hill       
## [2692] Capitol Hill        Capitol Hill        Capitol Hill       
## [2695] Capitol Hill        Capitol Hill        Capitol Hill       
## [2698] Capitol Hill        Capitol Hill        Capitol Hill       
## [2701] Capitol Hill        Capitol Hill        Capitol Hill       
## [2704] Capitol Hill        Capitol Hill        Capitol Hill       
## [2707] Capitol Hill        Capitol Hill        Capitol Hill       
## [2710] Capitol Hill        Capitol Hill        Capitol Hill       
## [2713] Capitol Hill        Capitol Hill        Capitol Hill       
## [2716] Capitol Hill        Capitol Hill        Capitol Hill       
## [2719] Capitol Hill        Capitol Hill        Capitol Hill       
## [2722] Capitol Hill        Capitol Hill        Capitol Hill       
## [2725] Capitol Hill        Capitol Hill        Capitol Hill       
## [2728] Capitol Hill        Capitol Hill        Capitol Hill       
## [2731] Capitol Hill        Capitol Hill        Capitol Hill       
## [2734] Capitol Hill        Capitol Hill        Capitol Hill       
## [2737] Capitol Hill        Capitol Hill        Capitol Hill       
## [2740] Capitol Hill        Capitol Hill        Capitol Hill       
## [2743] Capitol Hill        Capitol Hill        Capitol Hill       
## [2746] Capitol Hill        Capitol Hill        Capitol Hill       
## [2749] Capitol Hill        Capitol Hill        Capitol Hill       
## [2752] Capitol Hill        Capitol Hill        Capitol Hill       
## [2755] Capitol Hill        Capitol Hill        Capitol Hill       
## [2758] Capitol Hill        Capitol Hill        Capitol Hill       
## [2761] Capitol Hill        Capitol Hill        Capitol Hill       
## [2764] Capitol Hill        Capitol Hill        Capitol Hill       
## [2767] Capitol Hill        Capitol Hill        Capitol Hill       
## [2770] Capitol Hill        Capitol Hill        Capitol Hill       
## [2773] Capitol Hill        Capitol Hill        Capitol Hill       
## [2776] Capitol Hill        Capitol Hill        Capitol Hill       
## [2779] Capitol Hill        Capitol Hill        Capitol Hill       
## [2782] Capitol Hill        Capitol Hill        Capitol Hill       
## [2785] Capitol Hill        Capitol Hill        Capitol Hill       
## [2788] Capitol Hill        Capitol Hill        Capitol Hill       
## [2791] Capitol Hill        Capitol Hill        Capitol Hill       
## [2794] Capitol Hill        Capitol Hill        Capitol Hill       
## [2797] Capitol Hill        Capitol Hill        Capitol Hill       
## [2800] Capitol Hill        Capitol Hill        Capitol Hill       
## [2803] Capitol Hill        Capitol Hill        Capitol Hill       
## [2806] Capitol Hill        Capitol Hill        Capitol Hill       
## [2809] Capitol Hill        Capitol Hill        Capitol Hill       
## [2812] Capitol Hill        Capitol Hill        Capitol Hill       
## [2815] Capitol Hill        Capitol Hill        Capitol Hill       
## [2818] Capitol Hill        Capitol Hill        Capitol Hill       
## [2821] Capitol Hill        Capitol Hill        Capitol Hill       
## [2824] Capitol Hill        Capitol Hill        Capitol Hill       
## [2827] Capitol Hill        Capitol Hill        Capitol Hill       
## [2830] Capitol Hill        Capitol Hill        Capitol Hill       
## [2833] Capitol Hill        Capitol Hill        Capitol Hill       
## [2836] Capitol Hill        Capitol Hill        Capitol Hill       
## [2839] Capitol Hill        Capitol Hill        Capitol Hill       
## [2842] Capitol Hill        Capitol Hill        Capitol Hill       
## [2845] Capitol Hill        Capitol Hill        Capitol Hill       
## [2848] Capitol Hill        Capitol Hill        Capitol Hill       
## [2851] Capitol Hill        Capitol Hill        Capitol Hill       
## [2854] Capitol Hill        Capitol Hill        Capitol Hill       
## [2857] Capitol Hill        Capitol Hill        Capitol Hill       
## [2860] Capitol Hill        Capitol Hill        Capitol Hill       
## [2863] Capitol Hill        Capitol Hill        Capitol Hill       
## [2866] Capitol Hill        Capitol Hill        Capitol Hill       
## [2869] Capitol Hill        Capitol Hill        Capitol Hill       
## [2872] Capitol Hill        Capitol Hill        Capitol Hill       
## [2875] Capitol Hill        Capitol Hill        Capitol Hill       
## [2878] Capitol Hill        Capitol Hill        Capitol Hill       
## [2881] Capitol Hill        Capitol Hill        Capitol Hill       
## [2884] Capitol Hill        Capitol Hill        Capitol Hill       
## [2887] Capitol Hill        Capitol Hill        Capitol Hill       
## [2890] Capitol Hill        Capitol Hill        Capitol Hill       
## [2893] Capitol Hill        Capitol Hill        Capitol Hill       
## [2896] Capitol Hill        Capitol Hill        Capitol Hill       
## [2899] Capitol Hill        Capitol Hill        Capitol Hill       
## [2902] Capitol Hill        Capitol Hill        Capitol Hill       
## [2905] Capitol Hill        Capitol Hill        Capitol Hill       
## [2908] Capitol Hill        Capitol Hill        Capitol Hill       
## [2911] Capitol Hill        Capitol Hill        Capitol Hill       
## [2914] Capitol Hill        Capitol Hill        Capitol Hill       
## [2917] Capitol Hill        Capitol Hill        Capitol Hill       
## [2920] Capitol Hill        Capitol Hill        Capitol Hill       
## [2923] Capitol Hill        Capitol Hill        Capitol Hill       
## [2926] Capitol Hill        Capitol Hill        Capitol Hill       
## [2929] Capitol Hill        Capitol Hill        Capitol Hill       
## [2932] Capitol Hill        Capitol Hill        Capitol Hill       
## [2935] Capitol Hill        Capitol Hill        Capitol Hill       
## [2938] Capitol Hill        Capitol Hill        Capitol Hill       
## [2941] Capitol Hill        Capitol Hill        Capitol Hill       
## [2944] Capitol Hill        Capitol Hill        Capitol Hill       
## [2947] Capitol Hill        Capitol Hill        Capitol Hill       
## [2950] Capitol Hill        Capitol Hill        Capitol Hill       
## [2953] Capitol Hill        Capitol Hill        Capitol Hill       
## [2956] Capitol Hill        Capitol Hill        Capitol Hill       
## [2959] Capitol Hill        Capitol Hill        Capitol Hill       
## [2962] Capitol Hill        Capitol Hill        Capitol Hill       
## [2965] Capitol Hill        Capitol Hill        Capitol Hill       
## [2968] Capitol Hill        Capitol Hill        Capitol Hill       
## [2971] Capitol Hill        Capitol Hill        Ballard            
## [2974] Ballard             Ballard             Ballard            
## [2977] Ballard             Ballard             Ballard            
## [2980] Ballard             Ballard             Ballard            
## [2983] Ballard             Ballard             Ballard            
## [2986] Ballard             Ballard             Ballard            
## [2989] Ballard             Ballard             Ballard            
## [2992] Ballard             Ballard             Ballard            
## [2995] Ballard             Ballard             Ballard            
## [2998] Ballard             Ballard             Ballard            
## [3001] Ballard             Ballard             Ballard            
## [3004] Ballard             Ballard             Ballard            
## [3007] Ballard             Ballard             Ballard            
## [3010] Ballard             Ballard             Ballard            
## [3013] Ballard             Ballard             Ballard            
## [3016] Ballard             Ballard             Ballard            
## [3019] Ballard             Ballard             Ballard            
## [3022] Ballard             Ballard             Ballard            
## [3025] Lake City           Lake City           Lake City          
## [3028] Lake City           Lake City           Lake City          
## [3031] Lake City           Lake City           Lake City          
## [3034] Lake City           Lake City           Lake City          
## [3037] Lake City           Lake City           Lake City          
## [3040] Lake City           Lake City           Lake City          
## [3043] Lake City           Lake City           Lake City          
## [3046] Lake City           Lake City           Lake City          
## [3049] Lake City           Lake City           Lake City          
## [3052] Lake City           Lake City           Lake City          
## [3055] Lake City           Lake City           Lake City          
## [3058] Lake City           Ballard             Ballard            
## [3061] Ballard             Ballard             Ballard            
## [3064] Ballard             Ballard             Ballard            
## [3067] Ballard             Ballard             Ballard            
## [3070] Ballard             Ballard             Ballard            
## [3073] Ballard             Ballard             Ballard            
## [3076] Ballard             Ballard             Ballard            
## [3079] Ballard             Ballard             Ballard            
## [3082] Ballard             Ballard             Ballard            
## [3085] Lake City           Lake City           Lake City          
## [3088] Lake City           Lake City           Lake City          
## [3091] Lake City           Lake City           Lake City          
## [3094] Other neighborhoods Lake City           Lake City          
## [3097] Lake City           Lake City           Lake City          
## [3100] Lake City           Lake City           Lake City          
## [3103] Lake City           Lake City           Lake City          
## [3106] Lake City           Lake City           Lake City          
## [3109] Lake City           Lake City           Other neighborhoods
## [3112] Other neighborhoods Other neighborhoods Other neighborhoods
## [3115] Other neighborhoods Other neighborhoods Other neighborhoods
## [3118] Other neighborhoods Other neighborhoods Other neighborhoods
## [3121] Other neighborhoods Other neighborhoods Other neighborhoods
## [3124] Other neighborhoods Other neighborhoods Other neighborhoods
## [3127] Other neighborhoods Other neighborhoods Other neighborhoods
## [3130] Other neighborhoods Other neighborhoods Other neighborhoods
## [3133] Other neighborhoods Other neighborhoods Other neighborhoods
## [3136] Other neighborhoods Other neighborhoods Other neighborhoods
## [3139] Other neighborhoods Other neighborhoods Queen Anne         
## [3142] Queen Anne          Queen Anne          Queen Anne         
## [3145] Queen Anne          Queen Anne          Queen Anne         
## [3148] Queen Anne          Queen Anne          Queen Anne         
## [3151] Queen Anne          Queen Anne          Queen Anne         
## [3154] Queen Anne          Queen Anne          Queen Anne         
## [3157] Queen Anne          Queen Anne          Queen Anne         
## [3160] Queen Anne          Queen Anne          Queen Anne         
## [3163] Queen Anne          Queen Anne          Queen Anne         
## [3166] Queen Anne          Queen Anne          Queen Anne         
## [3169] Queen Anne          Queen Anne          Queen Anne         
## [3172] Queen Anne          Queen Anne          Queen Anne         
## [3175] Queen Anne          Queen Anne          Queen Anne         
## [3178] Queen Anne          Queen Anne          Queen Anne         
## [3181] Queen Anne          Queen Anne          Queen Anne         
## [3184] Queen Anne          Queen Anne          Queen Anne         
## [3187] Queen Anne          Queen Anne          Queen Anne         
## [3190] Queen Anne          Queen Anne          Queen Anne         
## [3193] Queen Anne          Queen Anne          Queen Anne         
## [3196] Queen Anne          Queen Anne          Queen Anne         
## [3199] Queen Anne          Queen Anne          Queen Anne         
## [3202] Queen Anne          Queen Anne          Queen Anne         
## [3205] Queen Anne          Queen Anne          Queen Anne         
## [3208] Queen Anne          Queen Anne          Queen Anne         
## [3211] Queen Anne          Queen Anne          Queen Anne         
## [3214] Queen Anne          Queen Anne          Queen Anne         
## [3217] Queen Anne          Queen Anne          Queen Anne         
## [3220] Queen Anne          Queen Anne          Queen Anne         
## [3223] Queen Anne          Queen Anne          Queen Anne         
## [3226] Queen Anne          Queen Anne          Queen Anne         
## [3229] Queen Anne          Queen Anne          Queen Anne         
## [3232] Queen Anne          Queen Anne          Queen Anne         
## [3235] Other neighborhoods Other neighborhoods Other neighborhoods
## [3238] Other neighborhoods Other neighborhoods Other neighborhoods
## [3241] Other neighborhoods Other neighborhoods Other neighborhoods
## [3244] Other neighborhoods Other neighborhoods Other neighborhoods
## [3247] Other neighborhoods Other neighborhoods Other neighborhoods
## [3250] Other neighborhoods Other neighborhoods Other neighborhoods
## [3253] Other neighborhoods Other neighborhoods Other neighborhoods
## [3256] Other neighborhoods Other neighborhoods Other neighborhoods
## [3259] Other neighborhoods Other neighborhoods Other neighborhoods
## [3262] Other neighborhoods Other neighborhoods Other neighborhoods
## [3265] Other neighborhoods Other neighborhoods Lake City          
## [3268] Lake City           Lake City           Lake City          
## [3271] Lake City           Lake City           Lake City          
## [3274] Lake City           Other neighborhoods Other neighborhoods
## [3277] Other neighborhoods Other neighborhoods Other neighborhoods
## [3280] Other neighborhoods Other neighborhoods Other neighborhoods
## [3283] Other neighborhoods Other neighborhoods Other neighborhoods
## [3286] Other neighborhoods Other neighborhoods Ballard            
## [3289] Ballard             Ballard             Ballard            
## [3292] Ballard             Ballard             Ballard            
## [3295] Ballard             Ballard             Ballard            
## [3298] Ballard             Ballard             Ballard            
## [3301] Ballard             Ballard             Ballard            
## [3304] Ballard             Ballard             Northgate          
## [3307] Northgate           Northgate           Northgate          
## [3310] Northgate           Northgate           Northgate          
## [3313] Northgate           Northgate           Northgate          
## [3316] Northgate           Northgate           Northgate          
## [3319] Northgate           Northgate           Northgate          
## [3322] Northgate           Northgate           Northgate          
## [3325] Northgate           Northgate           Northgate          
## [3328] Northgate           Northgate           Northgate          
## [3331] Northgate           Northgate           Northgate          
## [3334] Northgate           Northgate           Northgate          
## [3337] Northgate           Northgate           Northgate          
## [3340] Northgate           Northgate           Northgate          
## [3343] Northgate           Other neighborhoods Other neighborhoods
## [3346] Other neighborhoods Other neighborhoods Other neighborhoods
## [3349] Other neighborhoods Other neighborhoods Other neighborhoods
## [3352] Other neighborhoods Other neighborhoods Other neighborhoods
## [3355] Other neighborhoods Other neighborhoods Other neighborhoods
## [3358] Other neighborhoods Other neighborhoods Other neighborhoods
## [3361] Other neighborhoods Other neighborhoods Other neighborhoods
## [3364] Other neighborhoods Other neighborhoods Other neighborhoods
## [3367] Other neighborhoods Other neighborhoods Other neighborhoods
## [3370] Other neighborhoods Other neighborhoods Other neighborhoods
## [3373] Other neighborhoods Other neighborhoods Other neighborhoods
## [3376] Other neighborhoods Other neighborhoods Other neighborhoods
## [3379] Other neighborhoods Other neighborhoods Other neighborhoods
## [3382] Other neighborhoods Other neighborhoods Other neighborhoods
## [3385] Other neighborhoods Other neighborhoods Other neighborhoods
## [3388] Other neighborhoods Other neighborhoods Other neighborhoods
## [3391] Other neighborhoods Other neighborhoods Other neighborhoods
## [3394] Other neighborhoods Other neighborhoods Other neighborhoods
## [3397] Other neighborhoods Other neighborhoods Other neighborhoods
## [3400] Other neighborhoods Other neighborhoods Other neighborhoods
## [3403] Other neighborhoods Other neighborhoods Other neighborhoods
## [3406] Other neighborhoods Other neighborhoods Other neighborhoods
## [3409] Other neighborhoods Other neighborhoods Other neighborhoods
## [3412] Other neighborhoods Other neighborhoods Other neighborhoods
## [3415] Other neighborhoods Other neighborhoods Other neighborhoods
## [3418] Other neighborhoods Other neighborhoods Other neighborhoods
## [3421] Other neighborhoods Other neighborhoods Other neighborhoods
## [3424] Other neighborhoods Other neighborhoods Other neighborhoods
## [3427] Other neighborhoods Other neighborhoods Other neighborhoods
## [3430] Other neighborhoods Other neighborhoods Other neighborhoods
## [3433] Other neighborhoods Other neighborhoods Other neighborhoods
## [3436] Other neighborhoods Magnolia            Magnolia           
## [3439] Magnolia            Magnolia            Magnolia           
## [3442] Magnolia            Magnolia            Magnolia           
## [3445] Magnolia            Magnolia            Magnolia           
## [3448] Magnolia            Magnolia            Magnolia           
## [3451] Magnolia            Magnolia            Magnolia           
## [3454] Delridge            Delridge            Delridge           
## [3457] Delridge            Delridge            Delridge           
## [3460] Delridge            Delridge            Delridge           
## [3463] Delridge            Delridge            Delridge           
## [3466] Delridge            Delridge            West Seattle       
## [3469] West Seattle        West Seattle        West Seattle       
## [3472] West Seattle        West Seattle        West Seattle       
## [3475] West Seattle        West Seattle        West Seattle       
## [3478] West Seattle        West Seattle        Other neighborhoods
## [3481] Other neighborhoods Other neighborhoods Other neighborhoods
## [3484] Other neighborhoods Other neighborhoods Other neighborhoods
## [3487] Other neighborhoods Other neighborhoods Other neighborhoods
## [3490] Other neighborhoods Delridge            Delridge           
## [3493] Delridge            Delridge            Delridge           
## [3496] Delridge            Delridge            Delridge           
## [3499] Delridge            Delridge            Delridge           
## [3502] Delridge            Delridge            Capitol Hill       
## [3505] Capitol Hill        Capitol Hill        Capitol Hill       
## [3508] Capitol Hill        Capitol Hill        Capitol Hill       
## [3511] Capitol Hill        Capitol Hill        Capitol Hill       
## [3514] Capitol Hill        Capitol Hill        Capitol Hill       
## [3517] Capitol Hill        Capitol Hill        Capitol Hill       
## [3520] Capitol Hill        Capitol Hill        Capitol Hill       
## [3523] Capitol Hill        Capitol Hill        Capitol Hill       
## [3526] Capitol Hill        Capitol Hill        Capitol Hill       
## [3529] Capitol Hill        Capitol Hill        Capitol Hill       
## [3532] Capitol Hill        Capitol Hill        Capitol Hill       
## [3535] Capitol Hill        Capitol Hill        Capitol Hill       
## [3538] Capitol Hill        Capitol Hill        Capitol Hill       
## [3541] Capitol Hill        Capitol Hill        Capitol Hill       
## [3544] Capitol Hill        Capitol Hill        Capitol Hill       
## [3547] Capitol Hill        Capitol Hill        Capitol Hill       
## [3550] Capitol Hill        Capitol Hill        Capitol Hill       
## [3553] Capitol Hill        Capitol Hill        Capitol Hill       
## [3556] Capitol Hill        Capitol Hill        Capitol Hill       
## [3559] Capitol Hill        Capitol Hill        Capitol Hill       
## [3562] Capitol Hill        Capitol Hill        Capitol Hill       
## [3565] Capitol Hill        Capitol Hill        Capitol Hill       
## [3568] Capitol Hill        Capitol Hill        Capitol Hill       
## [3571] Capitol Hill        Capitol Hill        Capitol Hill       
## [3574] Capitol Hill        Capitol Hill        Capitol Hill       
## [3577] Capitol Hill        Capitol Hill        Capitol Hill       
## [3580] Capitol Hill        Capitol Hill        Capitol Hill       
## [3583] Capitol Hill        Capitol Hill        Capitol Hill       
## [3586] Capitol Hill        Capitol Hill        Capitol Hill       
## [3589] Capitol Hill        Capitol Hill        Capitol Hill       
## [3592] Capitol Hill        Capitol Hill        Capitol Hill       
## [3595] Capitol Hill        Capitol Hill        Capitol Hill       
## [3598] Capitol Hill        Capitol Hill        Capitol Hill       
## [3601] Capitol Hill        Capitol Hill        Capitol Hill       
## [3604] Capitol Hill        Capitol Hill        Capitol Hill       
## [3607] Capitol Hill        Capitol Hill        Capitol Hill       
## [3610] Capitol Hill        Capitol Hill        Capitol Hill       
## [3613] Capitol Hill        Capitol Hill        Capitol Hill       
## [3616] Capitol Hill        Capitol Hill        Capitol Hill       
## [3619] Capitol Hill        Capitol Hill        Capitol Hill       
## [3622] Capitol Hill        Capitol Hill        Capitol Hill       
## [3625] Capitol Hill        Capitol Hill        Capitol Hill       
## [3628] Capitol Hill        Capitol Hill        Capitol Hill       
## [3631] Capitol Hill        Capitol Hill        Capitol Hill       
## [3634] Capitol Hill        Capitol Hill        Capitol Hill       
## [3637] Capitol Hill        Capitol Hill        Capitol Hill       
## [3640] Other neighborhoods Other neighborhoods Other neighborhoods
## [3643] Other neighborhoods Other neighborhoods Other neighborhoods
## [3646] Other neighborhoods Other neighborhoods Other neighborhoods
## [3649] Other neighborhoods Other neighborhoods Other neighborhoods
## [3652] Other neighborhoods Other neighborhoods Other neighborhoods
## [3655] Other neighborhoods Other neighborhoods Other neighborhoods
## [3658] Other neighborhoods Other neighborhoods Other neighborhoods
## [3661] Other neighborhoods Other neighborhoods Other neighborhoods
## [3664] Other neighborhoods Other neighborhoods Other neighborhoods
## [3667] Other neighborhoods Other neighborhoods Other neighborhoods
## [3670] Other neighborhoods Other neighborhoods Other neighborhoods
## [3673] Other neighborhoods Other neighborhoods Other neighborhoods
## [3676] Other neighborhoods Other neighborhoods Other neighborhoods
## [3679] Other neighborhoods Other neighborhoods Other neighborhoods
## [3682] Other neighborhoods Other neighborhoods Other neighborhoods
## [3685] Other neighborhoods Other neighborhoods Other neighborhoods
## [3688] Other neighborhoods Other neighborhoods Other neighborhoods
## [3691] Other neighborhoods Other neighborhoods Other neighborhoods
## [3694] Other neighborhoods Other neighborhoods Other neighborhoods
## [3697] Other neighborhoods Other neighborhoods Other neighborhoods
## [3700] Other neighborhoods Other neighborhoods Other neighborhoods
## [3703] Other neighborhoods Other neighborhoods Other neighborhoods
## [3706] Other neighborhoods Other neighborhoods Other neighborhoods
## [3709] Other neighborhoods Other neighborhoods Other neighborhoods
## [3712] Other neighborhoods Other neighborhoods Other neighborhoods
## [3715] Other neighborhoods Other neighborhoods Other neighborhoods
## [3718] Other neighborhoods Other neighborhoods Other neighborhoods
## [3721] Other neighborhoods Other neighborhoods Other neighborhoods
## [3724] Other neighborhoods Other neighborhoods Other neighborhoods
## [3727] Other neighborhoods Other neighborhoods Other neighborhoods
## [3730] Other neighborhoods Other neighborhoods Other neighborhoods
## [3733] Other neighborhoods Other neighborhoods Other neighborhoods
## [3736] Other neighborhoods Other neighborhoods Other neighborhoods
## [3739] Other neighborhoods Other neighborhoods Other neighborhoods
## [3742] Other neighborhoods Other neighborhoods Other neighborhoods
## [3745] Other neighborhoods Other neighborhoods Other neighborhoods
## [3748] Other neighborhoods Other neighborhoods Other neighborhoods
## [3751] Other neighborhoods Other neighborhoods Other neighborhoods
## [3754] Other neighborhoods Other neighborhoods Other neighborhoods
## [3757] Other neighborhoods Other neighborhoods Other neighborhoods
## [3760] Other neighborhoods Other neighborhoods Other neighborhoods
## [3763] Other neighborhoods Other neighborhoods Other neighborhoods
## [3766] Other neighborhoods Other neighborhoods Other neighborhoods
## [3769] Other neighborhoods Other neighborhoods Other neighborhoods
## [3772] Other neighborhoods Other neighborhoods Other neighborhoods
## [3775] Other neighborhoods Other neighborhoods Other neighborhoods
## [3778] Other neighborhoods Other neighborhoods Other neighborhoods
## [3781] Other neighborhoods Other neighborhoods Other neighborhoods
## [3784] Other neighborhoods Other neighborhoods Other neighborhoods
## [3787] Other neighborhoods Other neighborhoods Other neighborhoods
## [3790] Other neighborhoods Other neighborhoods Other neighborhoods
## [3793] Other neighborhoods Other neighborhoods Other neighborhoods
## [3796] Other neighborhoods Other neighborhoods Other neighborhoods
## [3799] Other neighborhoods Other neighborhoods Other neighborhoods
## [3802] Other neighborhoods Other neighborhoods Other neighborhoods
## [3805] Other neighborhoods Other neighborhoods Other neighborhoods
## [3808] Other neighborhoods Other neighborhoods Other neighborhoods
## [3811] Other neighborhoods Other neighborhoods Other neighborhoods
## [3814] Other neighborhoods Capitol Hill        Rainier Valley     
## [3817] Capitol Hill        Queen Anne         
## 17 Levels: Ballard Beacon Hill Capitol Hill Cascade Central Area ... West Seattle
count(data_train, 'neighbourhood_group_cleansed')
count(data_train, 'neighbourhood_cleansed')
#Getting a count of listings per neighborhood
#write.csv(neigborhood_data, "neighborhoodcount.csv")
#count(data_train$neighbourhood_cleansed)
plot(data_train$neighbourhood_cleansed, xlab = 'Neighborhoods', ylab = 'Count')

neighborhood <- (data_train$neighbourhood_cleansed)
#x <- sort(count((neighborhood)))
#arrange(data_train, neighbourhood_cleansed)
neighborhood_data <- data_train[order(data_train[,21] ),]
summary(neighborhood_data$neighbourhood_cleansed)
##                     Adams                      Alki             Arbor Heights 
##                        70                        42                         5 
##                  Atlantic                  Belltown               Bitter Lake 
##                        53                       234                        13 
##                Briarcliff                  Brighton                 Broadview 
##                        14                        13                        17 
##                  Broadway                    Bryant                Cedar Park 
##                       397                        29                         8 
## Central Business District             Columbia City                Crown Hill 
##                       103                        58                        21 
##                    Dunlap           East Queen Anne                  Eastlake 
##                        20                        82                        45 
##            Fairmount Park                Fauntleroy                First Hill 
##                        29                        10                       108 
##                   Fremont                  Gatewood                   Genesee 
##                       158                        22                        34 
##                Georgetown                Green Lake                 Greenwood 
##                         8                        54                        89 
##               Haller Lake     Harrison/Denny-Blaine                High Point 
##                        15                        14                        14 
##             Highland Park                Holly Park       Industrial District 
##                        11                         6                         6 
##                  Interbay    International District               Laurelhurst 
##                        11                        17                        10 
##               Lawton Park                    Leschi          Lower Queen Anne 
##                        30                        53                        94 
##             Loyal Heights              Madison Park                   Madrona 
##                        52                        18                        47 
##                      Mann                Maple Leaf            Matthews Beach 
##                        67                        42                        19 
##               Meadowbrook           Mid-Beacon Hill                     Minor 
##                         9                        30                       135 
##                  Montlake               Mount Baker             North Admiral 
##                        19                        50                        49 
##    North Beach/Blue Ridge         North Beacon Hill        North College Park 
##                        14                        78                        19 
##            North Delridge          North Queen Anne             Olympic Hills 
##                        32                        54                        16 
##             Phinney Ridge               Pike-Market                 Pinehurst 
##                        73                        28                         4 
##            Pioneer Square               Portage Bay             Rainier Beach 
##                        23                        14                        18 
##                   Ravenna                 Riverview                 Roosevelt 
##                        67                         8                        30 
##                   Roxhill                   Seaview               Seward Park 
##                         2                        12                        44 
##         South Beacon Hill            South Delridge          South Lake Union 
##                         4                        12                        27 
##                South Park        Southeast Magnolia                   Stevens 
##                         3                        17                       119 
##               Sunset Hill       University District           Victory Heights 
##                        18                       122                        15 
##                View Ridge               Wallingford                  Wedgwood 
##                         7                       167                        18 
##           West Queen Anne             West Woodland                  Westlake 
##                        65                        64                        17 
##          Whittier Heights                Windermere            Yesler Terrace 
##                        26                        10                        17
#Trying to fix "Other Neighborhoods" value in neighborhood group cleaned column
#for(i in data_train)
 # if(i[neighbourhood_group_cleansed] == "Other neighborhoods")
  #  i[neighbourhood_group_cleansed] <-  i[neighborhood_cleansed]

#Plotting count of listings per neighborhood
neigborhood_data <- table(data_train$neighbourhood_cleansed)

barplot(sort(table(data_train$neighbourhood_group_cleansed), decreasing = TRUE), ylab = "Count",horiz = FALSE , main = "Distribution of Listings Per Neighborhood", beside = FALSE)

#barplot(table(data_train$neighbourhood_group_cleansed), density = 20, ylab = "Count",horiz = FALSE , main = "Distribution of Listings Per Neighborhood", beside = FALSE) + theme(axis.text.x = element_text(angle = 90, hjust = 1))
ggplot(data_train, aes(neighbourhood_group_cleansed)) + geom_bar(na.rm = TRUE, stat = "count") + theme(axis.text.x = element_text(angle = 90, hjust = 1))

  1. Looking at some more plots - Count of Host Listings
#barplot(data_train$host_listings_count, main = "Count of Host Listings", xlab = "", ylab = "Count") 
ggplot(data_train, aes(host_listings_count)) + geom_bar(na.rm = TRUE) + xlim(0,21) 

# Most hosts have a single Airbnb listing.

  1. Looking at Types of Airbnb properties
#barchart(data_train$property_type, main = "Types of Airbnb Properties", xlab = "Count")
prop_type <- table(data_train$property_type)
barplot(table(data_train$property_type), ylab = "Count",horiz = FALSE, main = "Types of Airbnb Properties", beside = FALSE, las = 1)

ggplot(data_train, aes(property_type)) + geom_bar(na.rm = TRUE, stat = "count") + theme(axis.text.x = element_text(angle = 90, hjust = 1))

#plot(data_train$host_is_superhost)
  1. Prices per nNeighborhood
z = table(data_train$room_type,data_train$neighbourhood_group)
kable(z)  %>%
  kable_styling(bootstrap_options = c("striped", "hover", "condensed","responsive"))
Ballard Beacon Hill Capitol Hill Cascade Central Area Delridge Downtown Interbay Lake City Magnolia Northgate Other neighborhoods Queen Anne Rainier Valley Seward Park University District West Seattle
Entire home/apt 148 57 384 62 225 41 471 5 31 41 41 492 231 76 27 74 135
Private room 82 58 143 24 140 38 42 6 36 19 35 274 62 79 17 38 67
Shared room 0 3 40 3 4 0 17 0 0 1 4 28 2 4 0 10 1
data_train %>% boxplot(price ~ neighbourhood_group_cleansed,data = ., main="Box Plot of price vs neighbourhood", 
                     ylab="neighbourhood", xlab="Price",horizontal=TRUE)

  1. Number of listings per neighborhood
ggplot(data_train, aes(x = fct_infreq(neighbourhood_cleansed), fill = room_type)) +
    geom_bar() +
    labs(title = "No. of listings by neighborhood",
         x = "Neighborhood", y = "No. of listings") +
    theme(legend.position = "bottom") + theme(axis.text.x = element_text(angle = 90, hjust = 1))

Looks messy, want to consider looking at only the top 10 neighborhoods

  1. Top 10 neighborhoods - doesn’t work - need to fix this
#top_10 <- data_train %>% group_by(neighborhood_cleansed) %>% tally()
#top_10 <- data_train %>% top_n(n = 10, wt = neighbourhood_group_cleansed) %>% arrange(neighbourhood_group_cleansed) %>% #summarize(neighbourhood_group_cleansed = n())

top_10 <- data_train[data_train$neighbourhood_group_cleansed %in% names(sort(table(data_train$neighbourhood_group_cleansed), decreasing = TRUE)[0:1]),]
#top_10 <- data_train %>% top_n(10) %>% group_by(neighbourhood_group_cleansed) %>% tally() 
top_10.val <- table(top_10$neighbourhood_group_cleansed)
kable(top_10.val)
Var1 Freq
Ballard 0
Beacon Hill 0
Capitol Hill 0
Cascade 0
Central Area 0
Delridge 0
Downtown 0
Interbay 0
Lake City 0
Magnolia 0
Northgate 0
Other neighborhoods 794
Queen Anne 0
Rainier Valley 0
Seward Park 0
University District 0
West Seattle 0
  1. Creating a variable to find the number of days since the listing has been on Airbnb
data_train$host_since <- as.Date(data_train$host_since)
data_train$host_since <- as.Date("2017-05-10")-data_train$host_since
  1. Looking at outliers for price
ggplot(data=data_train, aes(price)) + 
  geom_histogram(fill="red") + 
  labs(title="Histogram of Price") +
  labs(x="Price", y="Count")
## `stat_bin()` using `bins = 30`. Pick better value with `binwidth`.

# Percentile of price
quantile(data_train$price, c(.9, .95, .97, 0.975, 0.98, 0.99, 0.995, 0.999, 0.9999))
##      90%      95%      97%    97.5%      98%      99%    99.5%    99.9% 
## 225.0000 299.0000 350.0000 362.8750 399.6600 475.0000 556.4050 908.3330 
##   99.99% 
## 999.6183
  1. Room Type Analysis # For a private room
Private_rooms <- data_train %>% filter(room_type == "Private room")
Private_rooms$price %>% summary()
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   20.00   55.00   69.00   75.04   87.00  399.00

For an entire apartment

entire_house <- data_train %>% filter(room_type == "Entire home/apt")
entire_house$price %>% summary()
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    39.0    99.0   126.0   155.8   179.0  1000.0

#Shared room

shared_room <- data_train %>% filter(room_type == "Shared room")
shared_room$price %>% summary()
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   22.00   35.00   40.00   47.55   55.00  118.00
  1. Average prices for each room type
listingdf <- read.csv('data/listings.csv')
zipReviews <- listingdf %>% group_by(zipcode = zipcode) %>% summarise(avg_loc_review = mean(review_scores_location, na.rm = TRUE))

average_price <- data_train %>% group_by(room_type) %>% summarise(price = mean(price))
colnames(average_price)[1] <- "Room Type"
colnames(average_price)[2] <- "Average Price"
print((average_price))
## # A tibble: 3 x 2
##   `Room Type`     `Average Price`
##   <fct>                     <dbl>
## 1 Entire home/apt           156. 
## 2 Private room               75.0
## 3 Shared room                47.5
  1. Top 50 most expensive listings

Model Selection

  1. Clustering Used Clustering to compare which areas of Seattle have a higher concentration of airbnb listings.

Plotting the listings on the map of Seattle

#Reading Listings Data
listingdf <- read.csv('data/listings.csv')
#Creating a link for each pop up

#Creating Listings across Seattle
map <- leaflet(listingdf) %>%
  addTiles() %>%
  addMarkers(~longitude, ~latitude,labelOptions = labelOptions(noHide = T),
             clusterOptions = markerClusterOptions(),
             popup = paste0("<b> Name: </b>", listingdf$name , "<br/><b> Host Name: </b>", 
                            listingdf$host_name, "<br> <b> Price/night: </b>", listingdf$price, "<br/><b> Room Type: </b>", 
                            listingdf$room_type, "<br/><b> Property Type: </b>", listingdf$property_type
             )) %>% 
  setView(-122.335167, 47.608013, zoom = 11) %>%
  addProviderTiles("CartoDB.Positron")
map
mapshot(map, url = paste0(getwd(),"/map.html"))

This shows listings in a clustered fashion. Clicking on a cluster zooms into the listings belonging to it. Clicking on a pin gives you a pop up with some details about the property. We can see that most of the listings are clustered around Downtown and Cap Hill.

  1. Linear Regression without interaction Which variables influence price? Variables selected - bathrooms, price, property type, accomodates, bedrooms, room type
LM_res <- summary(lm(formula = (price) ~ room_type + accommodates + bedrooms + bathrooms + property_type, data = data_train))
plot(price ~room_type + accommodates + bedrooms + bathrooms + property_type + factor(neighbourhood_cleansed), data = data_train) + abline(lm(formula = price ~ room_type + accommodates + bedrooms + bathrooms, data = data_train))

## Warning in abline(lm(formula = price ~ room_type + accommodates + bedrooms + :
## only using the first two of 6 regression coefficients

## integer(0)
LM_res
## 
## Call:
## lm(formula = (price) ~ room_type + accommodates + bedrooms + 
##     bathrooms + property_type, data = data_train)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -248.19  -30.05   -5.72   19.49  864.28 
## 
## Coefficients:
##                               Estimate Std. Error t value Pr(>|t|)    
## (Intercept)                   -12.8106    61.5691  -0.208  0.83519    
## room_typePrivate room         -39.5198     2.8017 -14.106  < 2e-16 ***
## room_typeShared room          -64.7264     6.1441 -10.535  < 2e-16 ***
## accommodates                    9.6717     0.9163  10.555  < 2e-16 ***
## bedrooms                       30.8405     2.0250  15.230  < 2e-16 ***
## bathrooms                      32.4429     2.2245  14.584  < 2e-16 ***
## property_typeApartment         45.5618    61.5485   0.740  0.45919    
## property_typeBed & Breakfast   56.0995    62.4155   0.899  0.36881    
## property_typeBoat             173.9756    65.2768   2.665  0.00773 ** 
## property_typeBungalow          46.2783    63.8781   0.724  0.46882    
## property_typeCabin             42.2180    62.9800   0.670  0.50268    
## property_typeCamper/RV         73.2731    63.8601   1.147  0.25129    
## property_typeChalet            45.8405    87.0083   0.527  0.59833    
## property_typeCondominium       61.4535    61.8650   0.993  0.32060    
## property_typeDorm            -120.9482    76.1127  -1.589  0.11213    
## property_typeHouse             34.7890    61.5504   0.565  0.57196    
## property_typeLoft              70.3771    62.3116   1.129  0.25879    
## property_typeOther             33.5152    63.0066   0.532  0.59481    
## property_typeTent              19.3202    67.3993   0.287  0.77439    
## property_typeTownhouse         33.8528    61.8050   0.548  0.58391    
## property_typeTreehouse         71.0344    71.0587   1.000  0.31754    
## property_typeYurt              51.3528    87.0569   0.590  0.55531    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 61.51 on 3774 degrees of freedom
##   (22 observations deleted due to missingness)
## Multiple R-squared:  0.5399, Adjusted R-squared:  0.5373 
## F-statistic: 210.8 on 21 and 3774 DF,  p-value: < 2.2e-16

Results:

Private and Shared rooms, accommodates, bedrooms, bathrooms have a significant impact on price. So does Property Type = Boat - which is weird. R-square is 54%, which is not bad

  1. Taking log(price) with multiple regression:
LM_res2 <- summary(lm(formula = log_price ~ room_type + accommodates + bedrooms + bathrooms + property_type, data = data_train))
plot(price ~room_type + accommodates + bedrooms + bathrooms + property_type + factor(neighbourhood_cleansed), data = data_train) + abline(lm(formula = log_price ~ room_type + accommodates + bedrooms + bathrooms, data = data_train))

## Warning in abline(lm(formula = log_price ~ room_type + accommodates + bedrooms
## + : only using the first two of 6 regression coefficients

## integer(0)
LM_res2
## 
## Call:
## lm(formula = log_price ~ room_type + accommodates + bedrooms + 
##     bathrooms + property_type, data = data_train)
## 
## Residuals:
##      Min       1Q   Median       3Q      Max 
## -1.32206 -0.22705 -0.00963  0.20604  2.07682 
## 
## Coefficients:
##                               Estimate Std. Error t value Pr(>|t|)    
## (Intercept)                   4.092520   0.351772  11.634   <2e-16 ***
## room_typePrivate room        -0.452035   0.016007 -28.239   <2e-16 ***
## room_typeShared room         -0.875126   0.035104 -24.929   <2e-16 ***
## accommodates                  0.060103   0.005235  11.480   <2e-16 ***
## bedrooms                      0.167017   0.011570  14.436   <2e-16 ***
## bathrooms                     0.120528   0.012709   9.483   <2e-16 ***
## property_typeApartment        0.209460   0.351655   0.596   0.5514    
## property_typeBed & Breakfast  0.436483   0.356608   1.224   0.2210    
## property_typeBoat             0.695936   0.372956   1.866   0.0621 .  
## property_typeBungalow         0.156100   0.364964   0.428   0.6689    
## property_typeCabin            0.153733   0.359833   0.427   0.6692    
## property_typeCamper/RV        0.292263   0.364862   0.801   0.4232    
## property_typeChalet           0.284800   0.497118   0.573   0.5667    
## property_typeCondominium      0.304249   0.353463   0.861   0.3894    
## property_typeDorm            -0.671763   0.434866  -1.545   0.1225    
## property_typeHouse            0.133614   0.351665   0.380   0.7040    
## property_typeLoft             0.356222   0.356015   1.001   0.3171    
## property_typeOther            0.148702   0.359985   0.413   0.6796    
## property_typeTent            -0.255782   0.385083  -0.664   0.5066    
## property_typeTownhouse        0.170082   0.353120   0.482   0.6301    
## property_typeTreehouse        0.269078   0.405991   0.663   0.5075    
## property_typeYurt             0.211815   0.497395   0.426   0.6702    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 0.3514 on 3774 degrees of freedom
##   (22 observations deleted due to missingness)
## Multiple R-squared:  0.6171, Adjusted R-squared:  0.615 
## F-statistic: 289.7 on 21 and 3774 DF,  p-value: < 2.2e-16

Results: Transforming price to log has a higher R-squared value of 61%. Going forward, using log_price instead price.

  1. Linear Regression with interaction
LM_res3 <- summary(lm(formula = log_price ~ room_type * accommodates * bedrooms + bathrooms * property_type, data = data_train))
plot(log_price ~room_type * accommodates * bedrooms * bathrooms * property_type, data = data_train) + abline(lm(formula = price ~ room_type + accommodates + bedrooms + bathrooms, data = data_train))

## Warning in abline(lm(formula = price ~ room_type + accommodates + bedrooms + :
## only using the first two of 6 regression coefficients

## integer(0)
LM_res3
## 
## Call:
## lm(formula = log_price ~ room_type * accommodates * bedrooms + 
##     bathrooms * property_type, data = data_train)
## 
## Residuals:
##      Min       1Q   Median       3Q      Max 
## -1.36388 -0.22151 -0.01732  0.20443  2.09013 
## 
## Coefficients: (9 not defined because of singularities)
##                                              Estimate Std. Error t value
## (Intercept)                                  4.083627   0.352958  11.570
## room_typePrivate room                       -0.603820   0.038466 -15.698
## room_typeShared room                        -0.904871   0.067511 -13.403
## accommodates                                 0.054324   0.007897   6.879
## bedrooms                                     0.192029   0.015614  12.298
## bathrooms                                    0.127174   0.047336   2.687
## property_typeApartment                       0.120558   0.353691   0.341
## property_typeBed & Breakfast                 0.606165   0.362624   1.672
## property_typeBoat                            0.452158   0.416013   1.087
## property_typeBungalow                        0.155887   0.424065   0.368
## property_typeCabin                           0.156294   0.357180   0.438
## property_typeCamper/RV                       0.702012   0.430132   1.632
## property_typeChalet                          0.297482   0.493396   0.603
## property_typeCondominium                    -0.058474   0.367916  -0.159
## property_typeDorm                           -0.224133   0.544008  -0.412
## property_typeHouse                           0.149365   0.352489   0.424
## property_typeLoft                           -0.108541   0.398465  -0.272
## property_typeOther                           0.206509   0.386591   0.534
## property_typeTent                            0.025697   0.457424   0.056
## property_typeTownhouse                       0.180985   0.351422   0.515
## property_typeTreehouse                       0.302537   0.403053   0.751
## property_typeYurt                            0.231399   0.493735   0.469
## room_typePrivate room:accommodates           0.066017   0.015291   4.317
## room_typeShared room:accommodates            0.010126   0.035196   0.288
## room_typePrivate room:bedrooms                     NA         NA      NA
## room_typeShared room:bedrooms                      NA         NA      NA
## accommodates:bedrooms                       -0.003083   0.002314  -1.332
## bathrooms:property_typeApartment             0.088275   0.055143   1.601
## bathrooms:property_typeBed & Breakfast      -0.100755   0.061861  -1.629
## bathrooms:property_typeBoat                  0.152432   0.115053   1.325
## bathrooms:property_typeBungalow              0.013294   0.186162   0.071
## bathrooms:property_typeCabin                       NA         NA      NA
## bathrooms:property_typeCamper/RV            -0.478415   0.272617  -1.755
## bathrooms:property_typeChalet                      NA         NA      NA
## bathrooms:property_typeCondominium           0.305124   0.094388   3.233
## bathrooms:property_typeDorm                 -0.117676   0.077732  -1.514
## bathrooms:property_typeHouse                -0.002495   0.048307  -0.052
## bathrooms:property_typeLoft                  0.417811   0.165209   2.529
## bathrooms:property_typeOther                -0.037226   0.109249  -0.341
## bathrooms:property_typeTent                 -0.524746   0.497083  -1.056
## bathrooms:property_typeTownhouse                   NA         NA      NA
## bathrooms:property_typeTreehouse                   NA         NA      NA
## bathrooms:property_typeYurt                        NA         NA      NA
## room_typePrivate room:accommodates:bedrooms        NA         NA      NA
## room_typeShared room:accommodates:bedrooms         NA         NA      NA
##                                             Pr(>|t|)    
## (Intercept)                                  < 2e-16 ***
## room_typePrivate room                        < 2e-16 ***
## room_typeShared room                         < 2e-16 ***
## accommodates                                7.02e-12 ***
## bedrooms                                     < 2e-16 ***
## bathrooms                                    0.00725 ** 
## property_typeApartment                       0.73323    
## property_typeBed & Breakfast                 0.09469 .  
## property_typeBoat                            0.27716    
## property_typeBungalow                        0.71319    
## property_typeCabin                           0.66172    
## property_typeCamper/RV                       0.10275    
## property_typeChalet                          0.54659    
## property_typeCondominium                     0.87373    
## property_typeDorm                            0.68036    
## property_typeHouse                           0.67178    
## property_typeLoft                            0.78533    
## property_typeOther                           0.59325    
## property_typeTent                            0.95520    
## property_typeTownhouse                       0.60658    
## property_typeTreehouse                       0.45293    
## property_typeYurt                            0.63933    
## room_typePrivate room:accommodates          1.62e-05 ***
## room_typeShared room:accommodates            0.77359    
## room_typePrivate room:bedrooms                    NA    
## room_typeShared room:bedrooms                     NA    
## accommodates:bedrooms                        0.18287    
## bathrooms:property_typeApartment             0.10950    
## bathrooms:property_typeBed & Breakfast       0.10345    
## bathrooms:property_typeBoat                  0.18529    
## bathrooms:property_typeBungalow              0.94308    
## bathrooms:property_typeCabin                      NA    
## bathrooms:property_typeCamper/RV             0.07936 .  
## bathrooms:property_typeChalet                     NA    
## bathrooms:property_typeCondominium           0.00124 ** 
## bathrooms:property_typeDorm                  0.13014    
## bathrooms:property_typeHouse                 0.95881    
## bathrooms:property_typeLoft                  0.01148 *  
## bathrooms:property_typeOther                 0.73332    
## bathrooms:property_typeTent                  0.29120    
## bathrooms:property_typeTownhouse                  NA    
## bathrooms:property_typeTreehouse                  NA    
## bathrooms:property_typeYurt                       NA    
## room_typePrivate room:accommodates:bedrooms       NA    
## room_typeShared room:accommodates:bedrooms        NA    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 0.3488 on 3760 degrees of freedom
##   (22 observations deleted due to missingness)
## Multiple R-squared:  0.6243, Adjusted R-squared:  0.6208 
## F-statistic: 178.5 on 35 and 3760 DF,  p-value: < 2.2e-16

Results: R-square is at 62%.

  1. Pairwise comparison
# price vs bathrooms
p1 <- ggplot(data_train, aes(x=bathrooms, y=log_price)) +
  geom_point(colour = "orange", size = 1.5) +
  geom_smooth(method='lm', color='red') +
  ylab("price")

# price vs accommodates
p2 <- ggplot(data_train, aes(x=accommodates, y=log_price)) +
  geom_point(colour = "orange", size = 1.5) +
  geom_smooth(method='lm', color='red') +
  ylab("price")

# price vs bedrooms
p3 <- ggplot(data_train, aes(x=bedrooms, y=log_price)) +
  geom_point(colour = "orange", size = 1.5) +
  geom_smooth(method='lm', color='red') +
  ylab("price")

# price vs room_type
p4 <- ggplot(data_train, aes(x=room_type, y=log_price)) +
  geom_point(colour = "orange", size = 1.5) +
  geom_smooth(method='lm', color='red') +
  ylab("price")

# combining all plots
grid.arrange(p1, p2, p3, p4,ncol = 2)
## Warning: Removed 16 rows containing non-finite values (stat_smooth).
## Warning: Removed 16 rows containing missing values (geom_point).
## Warning: Removed 6 rows containing non-finite values (stat_smooth).
## Warning: Removed 6 rows containing missing values (geom_point).

  1. Predicting Price using Linear Regression Model
set.seed(100)
trainingRowIndex <- sample(1:nrow(data_train), 0.8 *nrow(data_train))
trainingData <- data_train[trainingRowIndex,]
testData <- data_train[-trainingRowIndex,]
lm_model <- lm(formula = log_price ~ room_type + accommodates + bedrooms + bathrooms, data = trainingData)
price_pred <- predict(lm_model, testData)

summary(lm_model)
## 
## Call:
## lm(formula = log_price ~ room_type + accommodates + bedrooms + 
##     bathrooms, data = trainingData)
## 
## Residuals:
##      Min       1Q   Median       3Q      Max 
## -1.04881 -0.23840 -0.02616  0.21672  2.08959 
## 
## Coefficients:
##                        Estimate Std. Error t value Pr(>|t|)    
## (Intercept)            4.289685   0.018896 227.020   <2e-16 ***
## room_typePrivate room -0.473831   0.016282 -29.102   <2e-16 ***
## room_typeShared room  -0.909211   0.040351 -22.533   <2e-16 ***
## accommodates           0.064303   0.005979  10.754   <2e-16 ***
## bedrooms               0.135775   0.012679  10.709   <2e-16 ***
## bathrooms              0.134488   0.014080   9.552   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 0.3538 on 3027 degrees of freedom
##   (21 observations deleted due to missingness)
## Multiple R-squared:  0.6061, Adjusted R-squared:  0.6055 
## F-statistic: 931.6 on 5 and 3027 DF,  p-value: < 2.2e-16
actual_pred <- data.frame(cbind(actuals = testData$log_price, predicteds = price_pred))
correlation_accuracy <- cor(actual_pred)

head(actual_pred)
  1. Correlation matrix
data.corr <- data_train %>% filter(!is.na(accommodates)) %>% filter(!is.na(bathrooms)) %>% filter(!is.na(bedrooms)) %>%
  select(log_price, price, bedrooms, bathrooms, accommodates)
kable(cor(data.corr)) %>% kable_styling()
log_price price bedrooms bathrooms accommodates
log_price 1.0000000 0.9012258 0.5782156 0.4264318 0.6642626
price 0.9012258 1.0000000 0.6281691 0.5164928 0.6519880
bedrooms 0.5782156 0.6281691 1.0000000 0.6109366 0.7716541
bathrooms 0.4264318 0.5164928 0.6109366 1.0000000 0.5386643
accommodates 0.6642626 0.6519880 0.7716541 0.5386643 1.0000000

Bedrooms, bathrooms and accommodates have a correlation with price.

  1. Create a CART model
# Implement CART model
library(rpart)
library(rpart.plot)
CARTmodel1 = rpart(log_price ~ bedrooms, data = data_train, cp =0.001)
prp(CARTmodel1)

  1. Making prediction?
set.seed(1)
trainingRowIndex <- sample(1:nrow(data_train), 0.8 *nrow(data_train))
trainingData <- data_train[trainingRowIndex,]
testData2 <- data_train[-trainingRowIndex,]

predTest <- predict(CARTmodel1, newdata = testData2)
SSE <- sum((predTest - testData2$log_price)^2)
SSE
## [1] 143.3704
RMSE <- sqrt((mean(predTest - testData2$log_price) ^ 2))
RMSE
## [1] 0.02622654
baseline <- mean(data_train$log_price)
baseline
## [1] 4.679227
SSEb <- sum((baseline- testData2$log_price) ^ 2)
SSEb
## [1] 233.226
Rsquared <- 1 - SSE/SSEb
Rsquared
## [1] 0.3852729
  1. Random Tree Forest? - Not working?
library(randomForest)
set.seed(1)
#RFmodel1 = randomForest(log_price ~ bedrooms + bathrooms + accommodates + room_type, data = testData2, nodesize = 20, ntree = 200)
RFmodel1 = randomForest(log_price ~ accommodates + bedrooms + bathrooms + room_type, data = testData, nodesize = 20, ntree = 200)

# Make predictions
predTest = predict(RFmodel1, newdata = testData2)
# SSE
SSE = sum((predTest - testData2$log_price)^2)
SSE
## [1] 74.71968
# RMSE
RMSE = sqrt(mean((predTest - testData2$log_price)^2))
RMSE
## [1] 0.3842751
# Baseline
baseline = mean(testData2$log_price)
baseline
## [1] 5.158113
# SSE of baseline model on testing set
SSEb = sum((baseline - testData2$log_price)^2)
SSEb
## [1] 210.6516
# R^2
Rsquared = 1 - SSE/SSEb
Rsquared
## [1] 0.6452926
  1. ANOVA - to compare categorical data
AOV_res <- summary(aov(log_price ~ factor(property_type) + factor(neighbourhood_cleansed), data = data_train))
AOV_res
##                                  Df Sum Sq Mean Sq F value   Pr(>F)    
## factor(property_type)            16   15.5  0.9664   3.433 4.09e-06 ***
## factor(neighbourhood_cleansed)   86  159.6  1.8557   6.593  < 2e-16 ***
## Residuals                      3715 1045.7  0.2815                     
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1

Results: As we can see, property type and neighborhood do have a significant impact on price since the p-value is much smaller than the significance level.